private void Form1_Load(object sender, System.EventArgs e)
{
SqlConnection objConn = new SqlConnection();
SqlCommand objComm = new SqlCommand();
SqlDataAdapter objDa = new SqlDataAdapter();
DataSet objDs = new DataSet(); objConn.ConnectionString = "Data Source=(local);Initial Catalog=Northwind;Integrated Security=SSPI";
objComm.CommandText = "Select * From Products";
objComm.Connection = objConn;
objDa.SelectCommand = objComm;
objConn.Open();
objDa.Fill(objDs, "products");
objConn.Close();
dataGrid1.DataSource = objDs.Tables["products"]; //combox methed 2 ok.
this.comboBox1.DataSource = objDs.Tables["products"];
this.comboBox1.DisplayMember = "ProductName";
this.textBox1.DataBindings.Add("Text", objDs, "products.ProductName"); this.listBox1.DataSource = objDs.Tables["products"];
this.listBox1.DisplayMember = "UnitPrice";
this.listBox1.ValueMember = "UnitPrice"; }
由于我是初学者,敬请各位指导谢谢.
{
SqlConnection objConn = new SqlConnection();
SqlCommand objComm = new SqlCommand();
SqlDataAdapter objDa = new SqlDataAdapter();
DataSet objDs = new DataSet(); objConn.ConnectionString = "Data Source=(local);Initial Catalog=Northwind;Integrated Security=SSPI";
objComm.CommandText = "Select * From Products";
objComm.Connection = objConn;
objDa.SelectCommand = objComm;
objConn.Open();
objDa.Fill(objDs, "products");
objConn.Close();
dataGrid1.DataSource = objDs.Tables["products"]; //combox methed 2 ok.
this.comboBox1.DataSource = objDs.Tables["products"];
this.comboBox1.DisplayMember = "ProductName";
this.textBox1.DataBindings.Add("Text", objDs, "products.ProductName"); this.listBox1.DataSource = objDs.Tables["products"];
this.listBox1.DisplayMember = "UnitPrice";
this.listBox1.ValueMember = "UnitPrice"; }
由于我是初学者,敬请各位指导谢谢.
解决方案 »
- 关于循环的问题,求指教!
- 高手帮忙看看,解释解释
- 50急,请各位大侠告诉我Combox找寻是否存在项的问题
- 我想学C#。NET 但是不知道买那本书好,请大虾们指点迷津!
- 急!怎样编程实现将光标定位到Infragistics.Win.UltraWinGrid.UltraGrid的某行某列的表格单元。
- 水晶报表工具栏无效!谢谢在线等
- 网页中使用word,出现Error=;Signa=;000014,什么错误,怎么解决?
- 呕出几十两血支持中国女足和男篮小散分
- 在C#中如何用代码改变水晶报表中的某一个标题或文本?急啊
- 请大家帮帮丽台啊
- 100分求网络聊天源码用socket的
- 一个程序进一步改进遇到的问题
this.textBox1.DataBindings.Add("Text", objDs.Tables["products"], "ProductName");
这种方式的话,那么就可以正常连动了.
请问,为什么呢?