基於vs2012的C# winform抽獎小程式的總結

標籤：

雜湊表的使用Hashtable hashtable = new Hashtable();hashtable.ContainsValue(tmp);//判斷雜湊表中有沒有tmphashtable.add(tmp,tmp);//加入雜湊表

DataSet的使用SqlDataAdapter sda = new SqlDataAdapter(sqlCount, myconn);DataSet ds = new DataSet();sda.Fill(ds);擷取ds裡的值ds.Tables[0].Rows[0]["欄位"]  或者 ds.Tables[0].Rows[0][0]

dataGridView的使用

SqlConnection myconn = new SqlConnection(conn);            myconn.Open();            SqlDataAdapter sda = new SqlDataAdapter(sql, myconn);            DataSet ds = new DataSet();            sda.Fill(ds, "Ticket");            dataGridView1.DataSource = ds;            dataGridView1.DataMember = "Ticket";
dataGridView1.Rows[i].Cells["欄位"].Value.ToString()；

 

 

雜湊表的遍曆

 foreach (DictionaryEntry de in hashtable2)

{

de.key;

de.value;

}

//將excel表匯入到dataSet

 1 //將excel表匯入到dataSet 2         public DataSet getXSLData(string filepath) 3         { 4             string strCon = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filepath + ";Extended Properties=\"Excel 12.0;HDR=YES;\""; 5             System.Data.OleDb.OleDbConnection Conn = new System.Data.OleDb.OleDbConnection(strCon); 6             string strCom = "SELECT * FROM [Sheet1$]"; 7             Conn.Open(); 8             System.Data.OleDb.OleDbDataAdapter myCommand = new System.Data.OleDb.OleDbDataAdapter(strCom, Conn); 9             DataSet ds = new DataSet();10             myCommand.Fill(ds, "[Sheet1$]");11             Conn.Close();12             return ds;13         }

openFileDialog的使用

OpenFileDialog ofd = new OpenFileDialog();            ofd.Filter = "Microsoft Excel files(*.xls)|*.xls;*.xlsx";//過濾一下，只要表格格式的            ofd.RestoreDirectory = true;            ofd.FilterIndex = 1;            ofd.AddExtension = true;            ofd.CheckFileExists = true;            ofd.CheckPathExists = true;            ofd.ShowHelp = true;//是否顯示協助按鈕            if (ofd.ShowDialog() == DialogResult.OK)            {                this.textBox1.Text = ofd.FileName;            }   

 

基於vs2012的C# winform抽獎小程式的總結