C語言_源代碼-C_界面編程小結(jié)

1、第一次C#界面編程備忘總結(jié)1、 給一個(gè)按鈕“瀏覽”增加save/open-Dialog對(duì)話框“瀏覽”中的程序：/僅僅是把對(duì)話框讀到的路徑顯示到openPath.Text中去if (openFileDialog1.ShowDialog() = DialogResult.OK) openPath.Text = openFileDialog1.FileName;/通過open-Dialog的FileOk事件(點(diǎn)擊"保存"或雙擊文件)打開某種文件using System.DiagnosticsProcess pro = new Process();pro.Start(); 2、 M

2、essageBoxMessageBox.Show(this, "串口已被占用!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);“串口.+ Environment.NewLine + ." (Environment.NewLine 表示回車)Buttons還有別的組合返回值的使用: /顯示信息框并得到返回值MessageBox.Show(.);返回類型有: DialogResult.Yes/DialogResult.No/DialogResult.Cancel/DialogRe

3、sult.No 3、 倒計(jì)時(shí)添加個(gè)interval=1000(默認(rèn)單位ms)的定時(shí)器:timer_timeDisplay定義個(gè)時(shí)間的數(shù)組timeDisplay,從界面獲取倒計(jì)時(shí)的總時(shí)間timeSumint timeDisplay = new int3;Int timeSum;/"開始"中初步處理代碼: .timeDisplay0 = (int)timeSum;timeDisplay1 = (int)(60 * (timeSum - timeDisplay0);timeDisplay2 = (int)(60*(60*(timeSum - timeDisplay0) - tim

4、eDisplay1);if (timeDisplay2 = 0 && timeDisplay1 != 0) timeDisplay2 = 60; timeDisplay1-; else if (timeDisplay2 = 0 && timeDisplay1 = 0) timeDisplay2 = 60; timeDisplay1 = 59; timeDisplay0-; timer_timeDisplay.Start();./倒計(jì)時(shí)顯示private void timer_timeDisplay_Tick(object sender, EventArgs e)

5、 timeSum-; if (timeDisplay2 != 0) timeDisplay2-; timeDisplay.Text = timeDisplay0 + "時(shí)" + timeDisplay1 + "分" + timeDisplay2 + "秒" if (timeDisplay2 = 0 && timeDisplay1 != 0) timeDisplay.Text = timeDisplay0 + "時(shí)" + timeDisplay1 + "分" + 00 + &quo

6、t;秒" timeDisplay1-; timeDisplay2 = 60; if (timeDisplay0 != 0 && timeDisplay1 = 0 && timeDisplay2 = 0) timeDisplay.Text = timeDisplay0 + "時(shí)" + 00 + "分" + timeDisplay2 + "秒" timeDisplay0-; timeDisplay1 = 59; timeDisplay2 = 60; if (timeDisplay0 = 0 &am

7、p;& timeDisplay1 = 0 && timeDisplay2 = 0) timer_timeDisplay.Stop(); MessageBox.Show(this, "時(shí)間到,測(cè)試結(jié)束 " + Environment.NewLine + "您可選擇其他操作!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); timeDisplay0 = (int)timeSum; timeDisplay1 = (int)(60 * (timeSu

8、m - timeDisplay0); timeDisplay2 = (int)(60*(60*(timeSum - timeDisplay0) - timeDisplay1); 4、 獲取路徑文件名 private string GetFileName(string path) int start, end; start = path.LastIndexOf(""); end = path.LastIndexOf(".");/如果有擴(kuò)展名時(shí) if (end < start) path = path.Substring(start + 1); els

9、e path = path.Substring(start + 1, end - start - 1); return path; 5、 連接已有模版數(shù)據(jù)庫文件/對(duì)數(shù)據(jù)庫操作時(shí)要添加public OleDbConnection connData = new OleDbConnectionpublic OleDbCommand cmd = new OleDbCommand();/連接數(shù)據(jù)庫,并寫入通過串口收到的數(shù)據(jù)private void DataToAccess(int times1, string voltage1, string dB_dBm1)cmd.CommandText = &quo

10、t;Insert Into testdata(num,voltage,dB_dBm) Values('" + times1 + "','" + voltage1 + "','" + dB_dBm1 + "')"cmd.Connection = connData;connData.Open();cmd.ExecuteNonQuery();cmd.Dispose();connData.Close();6、 拷貝模版數(shù)據(jù)庫文件到用戶指定pathtry/如果目標(biāo)文件已經(jīng)存在7、 將Ac

11、cess文件導(dǎo)入Excel文件要先添加引用/COM/Microsoft Exccel 11.0 Object Librarystring header = new string3 "num", "voltage", "dB_dBm" ;/建立Excel對(duì)象 /添加表頭myexcel.Cells1, 1 = "采樣時(shí)間間隔:"myexcel.Cells1, 3 = ts.Text + " s"myexcel.Cells2, 1 = "采樣總時(shí)間:"myexcel.Cells2,

12、 3 = th.Text + " h"for (int colomn = 0; colomn < 3; colomn+)myexcel.Cells4, colomn + 1 = headercolomn;/填充數(shù)據(jù)到Excel(從Access第二行開始導(dǎo)入)for (int j = 0; j < 3; j+)myexcel.Cellsi + 4, j + 1 = mytb.Rowsij.ToString();mybook.SaveCopyAs(savepath);mybook.Saved = true;/退出excelmyexcel.Quit();mybook = null;myexcel = null;mysheet = null;GC.Collect();MessageBox.Show(this, "導(dǎo)出EXCEL成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);return true;OleDbConnection connData1 = new OleDbConnectionOleDbCommand cmd1 = new OleDbCommand("SELEC