Question

ASP.NET中在母版页使用.fill（a，“table1”）函数总是报错

我在基于模板页的内容页中 前台放入一个textbox控件 一个button控件 一个gridview控件，然后在Button1_Click中写入如下代码：
DataSet myds = new DataSet();
string aaa = Request.Form.Get("TextBox1");
SqlConnection bbb = new SqlConnection("Data Source=A76;Initial Catalog=08_EmpDB;Persist Security Info=True;User ID=08;Password=08group");
string ccc = "select * from attendance where emp_num=" + aaa + "";
SqlDataAdapter ddd = new SqlDataAdapter(ccc, bbb);
ddd.Fill(myds,"table1");
GridView1.DataSource = myds;
GridView1.DataBind();
运行后总是提示ddd.fill(myds,"table1");错误 但是同样的方法在普通的页面中实现时是可以完成的；求大神知道呀

Answer 1

语句有错啊
"select * from attendance where emp_num=" + aaa + "";
emp_num = "+ aaa +""; 这样试试

Answer 2

"select * from attendance where emp_num='" + aaa + "'";
emp_num = '"+ aaa +"' 应该是 emp_num='值'

Answer 3

你仔细看看