DataGridView 和DataGrid使用例子.doc

查看文章 DataGridView 和DataGrid使用例子 2009年11月05日 星期四 23:59 /* Created by SharpDevelop.* User: * Date: 2009-9-22* Time: 14:51* * To change this template use Tools | Options | Coding | Edit Standard Headers.*/using System;using System.Collections.Generic;using System.Drawing;using System.Windows.Forms;using System.Data;using System.Data.SqlClient;namespace DataGridViewTest/ / Description of MainForm./ public partial class MainForm STAThread public static void Main(string args) Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); Application.Run(new MainForm(); public MainForm() / / The InitializeComponent() call is required for Windows Forms designer support. / InitializeComponent(); / / TODO: Add constructor code after the InitializeComponent() call. / private SqlConnection con; /连接数据库自定义函数 private void OpenConnection() try con=new SqlConnection(); con.ConnectionString = server = (local);database=lianxie;user id = sa;pwd=123; con.Open(); catch(SqlException ex) MessageBox.Show(ex.Message); /关闭数据库自定义函数 private void CloseConnection() if(this.con!=null & con.State!=System.Data.ConnectionState.Closed) this.con.Close(); /绑定 public void bind() OpenConnection(); try /方法一： string strSql = SELECT PRODUCT_NAME,BARCODE,AMOUNT,PRICE FROM MARKET ; SqlDataAdapter adapter = new SqlDataAdapter(strSql, con); DataSet dataset = new DataSet(); adapter.Fill(dataset);/填出数据集记录到dataadapter 适配器里 dataGrid1.DataSource=dataset; /dataGrid1 里添加数据 if (dataset.Tables0.Rows.Count 0) dataGridView1.Columns.Clear(); dataGridView1.DataSource = dataset; dataGridView1.DataMember = dataset.Tables0.ToString(); /向dataGridView1 里添加数据 /标题头设置 dataGridView1.Columns0.HeaderText = 商品名字; dataGridView1.Columns1.HeaderText = 货架; dataGridView1.Columns2.HeaderText = 总数量; dataGridView1.Columns3.HeaderText = 单价; else MessageBox.Show(没有您要查询的信息，请修改查询条件);/方法二：/ string strSql = SELECT * FROM MARKET ;/ SqlDataAdapter adapter = new SqlDataAdapter(strSql, con);/ DataSet dataset = new DataSet();/ adapter.Fill(dataset,market_test); /填出数据集记录到dataadapter 适配器里/ / if (dataset.Tables0.Rows.Count 0)/ / /dataGridView1 里添加数据/ dataGridView1.DataSource=dataset;/ dataGridView1.DataMember=market_test; / /标题头设置/ dataGridView1.Columns0.HeaderText = 商品名字;/ dataGridView1.Columns1.HeaderText = 货架;/ dataGridView1.Columns2.HeaderText = 总数量;/ dataGridView1.Columns3.HeaderText = 单价;/ / else/ MessageBox.Show(没有您要查询的