你的位置:首页 > ASP.net教程

[ASP.net教程]基于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;      }