資源描述:
《datagridview 和datagrid使用例子》由會員上傳分享,免費在線閱讀,更多相關(guān)內(nèi)容在行業(yè)資料-天天文庫。
1、查看文章?DataGridView和DataGrid使用例子2009年11月05日星期四23:59/**CreatedbySharpDevelop.*User:*Date:2009-9-22*Time:14:51**TochangethistemplateuseTools
2、Options
3、Coding
4、EditStandardHeaders.*/usingSystem;usingSystem.Collections.Generic;usingSystem.Drawing;usingSystem.Windows.Forms;usingSystem.D
5、ata;usingSystem.Data.SqlClient;namespaceDataGridViewTest{//////DescriptionofMainForm.///publicpartialclassMainForm{??[STAThread]??publicstaticvoidMain(string[]args)??{???Application.EnableVisualStyles();???Application.SetCompatibleTextRenderingDefault(false)
6、;???Application.Run(newMainForm());??}????publicMainForm()??{???//???//TheInitializeComponent()callisrequiredforWindowsFormsdesignersupport.???//???InitializeComponent();??????//???//TODO:AddconstructorcodeaftertheInitializeComponent()call.???//??}?????privateSqlConnectioncon;
7、??//連接數(shù)據(jù)庫自定義函數(shù)?????privatevoidOpenConnection()?????{?????try???{???????con=newSqlConnection();?????con.ConnectionString=@"server=(local);database=lianxie;userid=sa;pwd=123";??????con.Open();???}???catch(SqlExceptionex)???{??????MessageBox.Show(ex.Message);???}??}??//關(guān)閉數(shù)據(jù)庫自定義函數(shù)
8、??privatevoidCloseConnection()??{???if(this.con!=null&&con.State!=System.Data.ConnectionState.Closed)???{????this.con.Close();???}??}??//綁定???publicvoidbind()???{???OpenConnection();???try???{//方法一:??????stringstrSql="SELECTPRODUCT_NAME,BARCODE,AMOUNT,PRICEFROMMARKET";?????Sql
9、DataAdapteradapter=newSqlDataAdapter(strSql,con);?????DataSetdataset=newDataSet();?????adapter.Fill(dataset);//填出數(shù)據(jù)集記錄到dataadapter適配器里??????dataGrid1.DataSource=dataset;??????//dataGrid1里添加數(shù)據(jù)???????if(dataset.Tables[0].Rows.Count>0)???????????{??????????????dataGridView1.Colum
10、ns.Clear();??????????????dataGridView1.DataSource=dataset;??????????????dataGridView1.DataMember=dataset.Tables[0].ToString();???//向dataGridView1里添加數(shù)據(jù)??????????????//標題頭設(shè)置??????????????dataGridView1.Columns[0].HeaderText="商品名字";??????????????dataGridView1.Columns[1].HeaderText
11、="貨架";??????????????dataGridView1.Columns[2].HeaderText="總數(shù)量"