我目的是在text1中输入值后,按Button1事件后赋值给text2,text3protected void Button1_Click(object sender, EventArgs e)
{ //数据库SQLServer,SQL连接串
string ConnectionString1 = "Data Source=192.168.25.4;Initial Catalog=newcxgw;Persist Security Info=True;User ID=123;Password=ok"; using (SqlConnection conn = new SqlConnection(ConnectionString1))
{
// 打开连接
conn.Open();
// 1 准备SQL
//string _ID = TextBox1.Text;
string SQL = "SELECT * FROM limit where name= " + TextBox1.Text;
// 初始化SqlCommand
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
cmd.CommandText = SQL;
// 获取
SqlDataReader dataReader = cmd.ExecuteReader();
// 读取数据
if (dataReader.Read())
{
TextBox2.Text = "22";
TextBox3.Text = "33";
// ...
}
else
{
TextBox2.Text = "11";
TextBox3.Text = "44";
}
}
}
第 1 行: '=' 附近有语法错误。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: 第 1 行: '=' 附近有语法错误。源错误: 行 40: SqlDataReader dataReader = cmd.ExecuteReader();
错误
string SQL = "SELECT * FROM limit where name= '" + TextBox1.Text+"' ";
"SELECT * FROM limit where name='" + TextBox1.Text + "'";
http://topic.csdn.net/u/20080711/15/a104f624-74e2-4a63-8926-71a81d34334c.html
MS楼主不会结帖,失望ing...