" SELECT Adress " +
" FROM Customers " +
" WHERE CustomerID =textBox1.Text ";想在textBox1.Text手动输入数据,然后根据CustomerID=textBox1.Text 查询Adress的数据,第3行的语法有问题,请问该怎么改在线等.急,谢谢
" FROM Customers " +
" WHERE CustomerID =textBox1.Text ";想在textBox1.Text手动输入数据,然后根据CustomerID=textBox1.Text 查询Adress的数据,第3行的语法有问题,请问该怎么改在线等.急,谢谢
我在网上找的代码" WHERE CustomerID ='" & textBox1.Text & "'";
怎么会出错呀
你把sql放到查询分析器里看一下,能否执行啊
还有把错误帖一下
select adress from Customers where CustomerID=CustomerID试试看
" FROM Customers " +
" WHERE CustomerID =" + textBox1.Text ;
" FROM Customers " +
" WHERE CustomerID ='" + textBox1.Text +"'";
" FROM Customers " +
" WHERE CustomerID ='" + textBox1.Text.trim() +"'";
要把空格去掉
即:
SqlCommand cmd=new SqlCommand("SELECT Adress From Customers WHERE CustomerID= @CustomerID",con);
cmd.Parameters.AddWithValue("@CustomerID",Convert.ToInt32(textBox1.Text.Trim());//当然上面是在ID是int型的前提下,如果是Varchar型的..cmd.Parameters.AddWithValue("@CustomerID",textBox1.Text);