asp.net连接数据库的小问题请指教
我的数据库已经连接好，可是在填入用户名和密码时却总是登陆不成功请问这是为什么？
下面是我的代码
using System;
using System.Data;
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;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
this.txtUserName.Text = "";
this.txtUserPwd .Text= "";
}
}
protected void btnlogin_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("server=.;database=login;uid=sa;pwd=aaa;");
con.Open();
SqlCommand cmd = new SqlCommand("select count(*) from login where username='" + txtUserName + "' and userpwd='" + txtUserPwd + "'", con);
int count = Convert.ToInt32(cmd.ExecuteScalar());
if (count>0)
{
Response.Write("OK");
}
else
{
Response.Write("Error");
}
}
}
还有连接数据库时需要在ADD_Data文件夹下键一个类吗？谢谢
