datagridview 和datagrid使用例子

《datagridview 和datagrid使用例子》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

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{///

6、;   Application.Run(newMainForm());  }    publicMainForm()  {   //   //TheInitializeComponent()callisrequiredforWindowsFormsdesignersupport.   //   InitializeComponent();      //   //TODO:AddconstructorcodeaftertheInitializeComponent()call.   //  }     privateSqlConnectioncon;

7、  //连接数据库自定义函数     privatevoidOpenConnection()     {     try   {       con=newSqlConnection();     con.ConnectionString=@"server=(local);database=lianxie;userid=sa;pwd=123";      con.Open();   }   catch(SqlExceptionex)   {      MessageBox.Show(ex.Message);   }  }  //关闭数据库自定义函数

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);//填出数据集记录到dataadapter适配器里      dataGrid1.DataSource=dataset;      //dataGrid1里添加数据       if(dataset.Tables[0].Rows.Count>0)           {              dataGridView1.Colum

10、ns.Clear();              dataGridView1.DataSource=dataset;              dataGridView1.DataMember=dataset.Tables[0].ToString();   //向dataGridView1里添加数据              //标题头设置              dataGridView1.Columns[0].HeaderText="商品名字";              dataGridView1.Columns[1].HeaderText

11、="货架";              dataGridView1.Columns[2].HeaderText="总数量"