如题:
从对话框中拿到列名和值,语句如下:
string select = "SELECT * FORM NORTHWIND WHERE" + TextBox1.text + " = " + TextBox2.text;
这条语句通不过,我想表达的意思是:
string select = "SELECT * FROM NORTHWIND WHERE Name = 'Bob'";
在TextBox1中是”Name“
在TextBox2中是”Bob“
不知道说清楚没,我是菜鸟,求指点.
从对话框中拿到列名和值,语句如下:
string select = "SELECT * FORM NORTHWIND WHERE" + TextBox1.text + " = " + TextBox2.text;
这条语句通不过,我想表达的意思是:
string select = "SELECT * FROM NORTHWIND WHERE Name = 'Bob'";
在TextBox1中是”Name“
在TextBox2中是”Bob“
不知道说清楚没,我是菜鸟,求指点.
改成
string select = string.Format("SELECT * FORM NORTHWIND WHERE {0} = '{1}'", TextBox1.text, TextBox2.text);
应该就可以了~
string select = "SELECT * FORM NORTHWIND WHERE " + TextBox1.text + " = '" + TextBox2.text + "'";