我想动态的把数据库里的数据绑定到combox中但是引用未成功请指教!
代码如下:
public Form1()
{
try
{
string conn = "server=localhost;uid=ccc;pwd=ccc;database=northwind";
SqlConnection mySqlConnection = new SqlConnection(conn);
string mySql="Select * from Customers";
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter(mySql,mySqlConnection);
DataSet myDataSet;
myDataSet =new DataSet();
mySqlDataAdapter.Fill(myDataSet,"Customers");
comboBox1.DataSource=myDataSet.Tables["Customers"];
comboBox1.DisplayMember="CompanyName";
comboBox1.ValueMember="CustomerID";
}
catch(Exception e)
{
MessageBox.Show(e.ToString());
}
出错提示为
comboBox1.DataSource=myDataSet.Tables["Customers"]; 未将对象引用设置到对象的实例。
代码如下:
public Form1()
{
try
{
string conn = "server=localhost;uid=ccc;pwd=ccc;database=northwind";
SqlConnection mySqlConnection = new SqlConnection(conn);
string mySql="Select * from Customers";
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter(mySql,mySqlConnection);
DataSet myDataSet;
myDataSet =new DataSet();
mySqlDataAdapter.Fill(myDataSet,"Customers");
comboBox1.DataSource=myDataSet.Tables["Customers"];
comboBox1.DisplayMember="CompanyName";
comboBox1.ValueMember="CustomerID";
}
catch(Exception e)
{
MessageBox.Show(e.ToString());
}
出错提示为
comboBox1.DataSource=myDataSet.Tables["Customers"]; 未将对象引用设置到对象的实例。
实在不行你再新建个项目,手动拖一下comboBox控件到窗体,然后再复制过这段代码去.