求助高手,一C#SQL的,在等.......
我想在C#里面,textbox里得到,然後去查,得到一字段的,得到些值後,把值一listbox,高手指教怎做。我的代如下,不很多地方不。
string strbox2 = txtbox2.Text;
string strbox3 = txtbox3.Text;
string Querystr = "select 品名, from ModProcure.dbo.BF where 品名 like ' " + strbox2 + "% ' AND like ' " + strbox3 + "% ' ";
conn.Open();
SqlCommand cmd = new SqlCommand(Querystr, conn);
SqlDataReader Query_value = cmd.ExecuteReader();
if (Query_value.VisibleFieldCount < 1)
{
MessageBox.Show( "您入的模具名有,重新入 ");
}
else
{
Query_value.Close();
string Querystr1 = "SELECT PicPath FROM ModProcure.dbo.M_Mod_Data2 WHERE Pno= ' " + strbox2 + " ' AND Kind= ' " + strbox3 + " ' ";
//Console.Write(Querystr1);
SqlCommand cmd1 = new SqlCommand(Querystr1, conn);
SqlDataReader Query_value1 = cmd1.ExecuteReader();
//getpath = Query_value1.GetValue(0);
//Console.Write(Query_value1.GetString(0));
//if (Query_value1.VisibleFieldCount < 1)
//{
// MessageBox.Show( "此模具片! ");
//}
//else
//{
txtbox4.Text = Query_value1.GetString(0);
// getpath = Query_value1[ "PicPath "].ToString().Trim();
// //txtbox4 =getpath;
//txtbox4.Text =Query_value1[ "PicPath "].ToString().Trim();
//txtbox4.Text = Query_value1.GetValue(1).ToString();
// //MessageBox.Show( "迎! ");
}
[解决办法]
string strbox2 = txtbox2.Text;
string strbox3 = txtbox3.Text;
string Querystr = "select 品名, from ModProcure.dbo.BF where 品名 like ' " + strbox2 + "% ' AND like ' " + strbox3 + "% ' ";
conn.Open();
SqlCommand cmd = new SqlCommand(Querystr, conn);
SqlDataReader Query_value = cmd.ExecuteReader();
if (Query_value.VisibleFieldCount < 1)
{
MessageBox.Show( "您入的模具名有,重新入 ");
}
else
{//绑定数据了哈.把他那ListBox的数据源myListBox.DataSource=Query_value(0);
具体的改成相应的列,应该就可以了