各位大侠,我搞个登陆页面,但都是有问题的,本人菜鸟,帮我看看要怎么改才对
代码是
<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>--------------------
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection sqlcon = new SqlConnection();
sqlcon.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
sqlcon.Open();
string sql1 = "select * FROM Table1 WHERE name='" + name.Text + " ' and paw='" + paw.Text + " '";
SqlCommand sqlcmd = new SqlCommand(sql1, sqlcon); SqlDataReader ss = sqlcmd.ExecuteReader();
if (ss.Read())
{
Label1.Text = name.Text;
}
}
---------------------
运行当当按按钮时候提示:
“/Documents1”应用程序中的服务器错误。
--------------------------------------------------------------------------------
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: '=' 附近有语法错误。源错误: 行 28: SqlDataReader ss = sqlcmd.ExecuteReader();
代码是
<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>--------------------
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection sqlcon = new SqlConnection();
sqlcon.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
sqlcon.Open();
string sql1 = "select * FROM Table1 WHERE name='" + name.Text + " ' and paw='" + paw.Text + " '";
SqlCommand sqlcmd = new SqlCommand(sql1, sqlcon); SqlDataReader ss = sqlcmd.ExecuteReader();
if (ss.Read())
{
Label1.Text = name.Text;
}
}
---------------------
运行当当按按钮时候提示:
“/Documents1”应用程序中的服务器错误。
--------------------------------------------------------------------------------
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: '=' 附近有语法错误。源错误: 行 28: SqlDataReader ss = sqlcmd.ExecuteReader();
改成:
string sql1 = "select * FROM Table1 WHERE [name]='" + name.Text + " ' and [paw]='" + paw.Text + " '";
<add key="ConnectionSql" value="server=(local);User ID=sa;Password=sa;database=TEST"/>
select * FROM Table1 WHERE name='123' and paw='234'
{
Label1.Text = name.Text;
}
看看行不??
string sql1 = "select * FROM Table1 WHERE name='" + name.Text + " ' and paw='" + paw.Text + " '";
应该是这里的 name.Text or paw.Text有为“”或者是null得可能吧!最好是设置断点跟踪一下看看!