哪位大佬给我看看,一直说
System.Data.SqlClient.SqlException:附近有语法错误
下面是我的代码
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
namespace projict1
{
public partial class login : System.Web.UI.Page
{
private SqlConnection sqlcon = new SqlConnection();
private SqlCommand sqlcmd;
protected void Page_Load(object sender, EventArgs e)
{
sqlcon.ConnectionString = @"server=HE; database=Student;trusted_connection=true";
try
{
sqlcon.Open();
sqlcmd = sqlcon.CreateCommand();
}
catch (Exception)
{
Response.End();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string t_name = UserName.Text;
string t_password = PassWord.Text;
sqlcmd.CommandText = "select * from Student.dbo.tbl_User where username'" + t_name + "'";
SqlDataReader sqldr = sqlcmd.ExecuteReader();
if (sqldr.Read())
{
if (sqldr.GetValue(1).ToString()== t_password)
{
sqlcon.Close();
Response.Redirect("search.aspx");
}
else
{
Response.Write("<script>alert('密码错误')</script>");
}
}
else {
Response.Write("<script>alert('用户名不存在')</script>");
}
}
}
}