现在我用 SqlConnection myconn = new SqlConnection();
myconn.ConnectionString = "Data Source= ;Initial Catalog= ;Integrated Security=True;";
if (myconn != null)
{
myconn.Open();
string selestr = "select ID from 地理特征 where 资源种类='" + comboBox1.SelectedValue.ToString() + "'";
SqlCommand mycomm = new SqlCommand(selestr, myconn);
SqlDataReader sdr = mycomm.ExecuteReader();
if (sdr.Read())
{
listBox1.Items .Add (sdr["ID"].ToString());
}
}
我想将select语句提出的ID逐项显示在Listbox中,请问这样可以么?
myconn.ConnectionString = "Data Source= ;Initial Catalog= ;Integrated Security=True;";
if (myconn != null)
{
myconn.Open();
string selestr = "select ID from 地理特征 where 资源种类='" + comboBox1.SelectedValue.ToString() + "'";
SqlCommand mycomm = new SqlCommand(selestr, myconn);
SqlDataReader sdr = mycomm.ExecuteReader();
if (sdr.Read())
{
listBox1.Items .Add (sdr["ID"].ToString());
}
}
我想将select语句提出的ID逐项显示在Listbox中,请问这样可以么?
然后在后台循环datatable的数据,添加到listbox里面。
if (sdr.Read())
{
listBox1.Items .Add (sdr["ID"].ToString());
}if (sdr1.Read())
{
listBox1.Items .Add (sdr1["ID"].ToString());
}if (sdr2.Read())
{
listBox1.Items .Add (sdr2["ID"].ToString());
}