哈希表的使用 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; }