C语言-源代码-C-界面编程小结.doc

第一次C#界面编程备忘总结1、 给一个按钮“浏览”增加save/open-Dialog对话框“浏览”中的程序：/仅仅是把对话框读到的路径显示到openPath.Text中去if (openFileDialog1.ShowDialog() = DialogResult.OK) openPath.Text = openFileDialog1.FileName;/通过open-Dialog的FileOk事件(点击保存或双击文件)打开某种文件using System.DiagnosticsSystem.IO.FileInfo oppen1 = new System.IO.FileInfo(openFileDialog1.FileName);Process pro = new Process();pro.StartInfo.FileName = openFileDialog1.FileName;pro.StartInfo.WorkingDirectory = oppen1.DirectoryName;pro.Start(); 2、 MessageBoxMessageBox.Show(this, 串口已被占用!, 提示, MessageBoxButtons.OK, MessageBoxIcon.Information);“串口.+ Environment.NewLine + . (Environment.NewLine 表示回车)Buttons还有别的组合返回值的使用: /显示信息框并得到返回值System.Windows.Forms.DialogResult rt = MessageBox.Show(.);返回类型有: DialogResult.Yes/DialogResult.No/DialogResult.Cancel/DialogResult.No 3、 倒计时添加个interval=1000(默认单位ms)的定时器:timer_timeDisplay定义个时间的数组timeDisplay,从界面获取倒计时的总时间timeSumint timeDisplay = new int3;Int timeSum;/开始中初步处理代码: .timeDisplay0 = (int)timeSum;timeDisplay1 = (int)(60 * (timeSum - timeDisplay0);timeDisplay2 = (int)(60*(60*(timeSum - timeDisplay0) - timeDisplay1);if (timeDisplay2 = 0 & timeDisplay1 != 0) timeDisplay2 = 60; timeDisplay1-; else if (timeDisplay2 = 0 & timeDisplay1 = 0) timeDisplay2 = 60; timeDisplay1 = 59; timeDisplay0-; timer_timeDisplay.Start();./倒计时显示private void timer_timeDisplay_Tick(object sender, EventArgs e) timeSum-; if (timeDisplay2 != 0) timeDisplay2-; timeDisplay.Text = timeDisplay0 + 时 + timeDisplay1 + 分 + timeDisplay2 + 秒; if (timeDisplay2 = 0 & timeDisplay1 != 0) timeDisplay.Text = timeDisplay0 + 时 + timeDisplay1 + 分 + 00 + 秒; timeDisplay1-; timeDisplay2 = 60; if (timeDisplay0 != 0 & timeDisplay1 = 0 & timeDisplay2 = 0) timeDisplay.Text = timeDisplay0 + 时 + 00 + 分 + timeDisplay2 + 秒; timeDisplay0-; timeDisplay1 = 59; timeDisplay2 = 60; if (timeDisplay0 = 0 & timeDisplay1 = 0 & timeDisplay2 = 0) timer_timeDisplay.Stop(); MessageBox.Show(this, 时间到,测试结束 + Environment.NewLine + 您可选择其他操作!, 提示, MessageBoxButtons.OK, MessageBoxIcon.Information); timeDisplay0 = (int)timeSum; timeDisplay1 = (int)(60 * (timeSum - timeDisplay0); timeDisplay2 = (int)(60*(60*(timeSum - timeDisplay0) - timeDisplay1); 4、 获取路径文件名 private string GetFileName(string path) int start, end; start = path.LastIndexOf(); end = path.LastIndexOf(.);/如果有扩展名时 if (end start) path = path.Substring(start + 1); else path = path.Substring(start + 1, end - start - 1); return path; 5、 连接已有模版数据库文件using System.Data.OleDb;/对数据库操作时要添加using System.Runtime.InteropServices;public OleDbConnection connData = new OleDbConnection (Provider=Microsoft.Jet.OLEDB.4.0;Data Source= + System.Windows.Forms.Application.StartupPath + test.mdb);public OleDbCommand cmd = new OleDbCommand();/连接数据库,并写入通过串口收到的数据private void DataToAccess(int times1, string voltage1, string dB_dBm1)cmd.CommandText = Insert Into testdata(num,voltage,dB_dBm) Values( + times1 + , + voltage1 + , + dB_dBm1 + );cmd.Connection = connData;connData.Open();cmd.ExecuteNonQuery();cmd.Dispose();connData.Close();6、 拷贝模版数据库文件到用户指定pathtrySystem.IO.File.Copy(System.Windows.Forms.Application.StartupPath + test.mdb, path.Text);connData.ConnectionString = Provider=Microsoft.Jet.OLEDB.4.0;Data Source= + path.Text;catch (System.IO.IOException)/如果目标文件已经存在System.IO.File.Copy(System.Windows.Forms.Application.StartupPath + test.mdb, path.Text, true);connData.ConnectionString = Provider=Microsoft.Jet.OLEDB.4.O;Data Source= + path.Text;7、 将Access文件导入Excel文件要先添加引用/COM/Microsoft Exccel 11.0 Object Libraryusing Microsoft.Office.Interop.Excel;public bool DataToExcel(System.Data.DataTable mytb, string savepath)string header = new string3 num, voltage, dB_dBm ;/建立Excel对象 Microsoft.Office.Interop.Excel.Application myexcel;Microsoft.Office.Interop.Excel._Workbook mybook;Microsoft.Office.Interop.Excel._Worksheet mysheet = null;myexcel = new Microsoft.Office.Interop.Excel.ApplicationClass();mybook = myexcel.Workbooks.Add(true);mysheet = (Microsoft.Office.Interop.Excel._Worksheet)mybook.ActiveSheet;/添加表头myexcel.Cells1, 1 = 采样时间间隔:;myexcel.Cells1, 3 = ts.Text + s;myexcel.Cells2, 1 = 采样总时间:;myexcel.Cells2, 3 = th.Text + h;for (int colomn = 0; colomn 3; colomn+)myexcel.Cells4, colomn + 1 = headercolomn;/填充数据到Excel(从Access第二行开始导入)for (int i = 1; i mytb.Rows.Count; i+)for (int j = 0; j 3; j+)myexcel.Cellsi + 4, j + 1 = mytb.Rowsij.ToString();mybook.SaveCopyAs(savepath);mybook.Saved = true;/退出excelmyexcel.Quit();System.Runtime.InteropServices.Marshal.ReleaseComObject(mybook);System.Runtime.InteropServices.Marshal.ReleaseComObject(myexcel);System.Runtime.InteropServices.Marshal.ReleaseComObject(mysheet);mybook = null;myexcel = null;mysheet = null;GC.Collect();MessageBox.Show(this, 导出EXCEL成功!, 提示, MessageBoxButtons.OK, MessageBoxIcon.Information);return true;OleDbConnection connData1 = new OleDbConnection (Provider=Microsoft.Jet.OLEDB.4.0;Data Source= + System.Windows.Forms.Application.Startup