Question

在 System.Data.SqlClient.SqlException 中第一次偶然出现的“System.Data.dll”类型的异常

protected void Button3_Click(object sender, EventArgs e)
{
Response.Redirect("Manager/ManagerIndex.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
string userid = TextBox1.Text.Trim();
string username = TextBox2.Text.Trim();
string password = TextBox3.Text.Trim();
string beizhu = TextBox4.Text.Trim();
string quanxian = TextBox5.Text.Trim();

string college = DropDownList2.SelectedItem.Value;
string stuclass = DropDownList3.SelectedItem.Value;
string name = FileUpload1.FileName;
string serverPath = Server.MapPath("~/");
string paths = serverPath+"Photo\\" + name;
FileUpload1.SaveAs(paths);
select sl = new select();
if (sl.jianchaxuesheng(userid)==true)
{

Insert insert = new Insert();
if (insert.InsertStudent(userid, username, password, college, stuclass, paths, beizhu, quanxian))
Response.Write("<script>alert('提交成功！')</script>");
else
Response.Write("<script>alert('提交失败！')</script>");

Image1.ImageUrl = "~\\Photo\\" + name;
}

Answer 1

st1 构造有错误，右侧少了一个单引号，like后面加个空格

st1=L"select * from KC where km like '"+textBox1->Text+"%'"
改成上面的试试

追问

详细点吧 我的这个代码怎么改

Answer 2

具体出现什么错误,因为代码中只有一句跟数据库有关的代码,就是往数据库中添加学生信息,insert.InsertStudent(userid, username, password, college, stuclass, paths, beizhu, quanxian)但从这句代码中看不出有什么问题,所以希望能把错误信息说的清楚点