22,210
社区成员
发帖
与我相关
我的任务
分享
//参考...
SqlConnection conn=new SqlConnection("server=.;database=DB;user id=sa;password=***")
SqlDataAdapter dap=new SqlDataAdapter("select col from table",conn)
DataSet dt=new DataSet();
conn.Open();
dap.Fill(dt);
conn.Close(); //忘记关闭连接了!呵呵...
this.comboBox1.Items.Clear();
int i = 0;
while (i < Convert.ToInt32(dt.Tables[0].Rows.Count))
{
this.comboBox1.Items.Add(dt.Tables[0].Rows[i][0].ToString());
i++;
}
//参考...
SqlConnection conn=new SqlConnection("server=.;database=DB;user id=sa;password=***")
SqlDataAdapter dap=new SqlDataAdapter("select col from table",conn)
DataSet dt=new DataSet();
conn.Open();
dap.Fill(dt);
this.comboBox1.Items.Clear();
int i = 0;
while (i < Convert.ToInt32(dt.Tables[0].Rows.Count))
{
this.comboBox1.Items.Add(dt.Tables[0].Rows[i][0].ToString());
i++;
}