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

哈希表的使用

Hashtable hashtable = new Hashtable();

hashtable.ContainsValue(tmp);//判斷哈希表中有沒有tmp
hashtable.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;
            }