请大家帮忙看看是怎么回事,我看了半天找不出哪出错了
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ }
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection cn = new SqlConnection("server=.;database=admin;uid=sa;pwd=");
cn.Open();
string strsql = "select name,pwd from admin where name='" + name.Text + "' or pwd='" + pwd.Text + "'";
SqlCommand cmd = new SqlCommand(strsql, cn);
SqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
if (rd.GetValue(0).ToString() == name.Text)
{
if (rd.GetValue(1).ToString() == pwd.Text)
{
Response.Redirect("index.aspx");
}
else
{
Response.Write("<script>alert('密码错误!')</script>");
}
}
else
{
Response.Write("<script>alert('用户名错误!')</script>");
}
}
else
{
Response.Write("<script>alert('用户不存在!')</script>");
}
}
}
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ }
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection cn = new SqlConnection("server=.;database=admin;uid=sa;pwd=");
cn.Open();
string strsql = "select name,pwd from admin where name='" + name.Text + "' or pwd='" + pwd.Text + "'";
SqlCommand cmd = new SqlCommand(strsql, cn);
SqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
if (rd.GetValue(0).ToString() == name.Text)
{
if (rd.GetValue(1).ToString() == pwd.Text)
{
Response.Redirect("index.aspx");
}
else
{
Response.Write("<script>alert('密码错误!')</script>");
}
}
else
{
Response.Write("<script>alert('用户名错误!')</script>");
}
}
else
{
Response.Write("<script>alert('用户不存在!')</script>");
}
}
}
在确认数据库的名称以及sa用户的密码
看看与你的语句有冲突没
还有如果是sql2005的那个server=./express
不记得后面是个什么了。反正后面有个东西,不能用.来全部代替。