UC知道求一段登陆代码（Microsoft Visual Studio 2005）
来源：百度知道 编辑：UC知道 时间：2024/05/21 08:56:31
我用的是Microsoft Visual Studio 2005，数据库他自带的，
还有指导下我 ，我的代码如下
string User = this.TextBox1.Text;
string Pwd = this.TextBox2.Text;
string str = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Database.mdf;Integrated Security=True;User Instance=True";
SqlConnection conn = new SqlConnection(str);
SqlDataAdapter da = new SqlDataAdapter("select * from Table1", conn);
conn.Open();
da.SelectCommand.CommandText = "select * from Table1 where 帐号='" + User + " ' and 密码=' " + Pwd + " '";
DataSet ds = new DataSet();
int counts = da.Fill(ds, "Table1");
if (counts == 1)
{
Response.Redirect("Default4.aspx");
}
else
{
Label1.Text = "<script>alert('!!!&
还有指导下我 ，我的代码如下
string User = this.TextBox1.Text;
string Pwd = this.TextBox2.Text;
string str = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Database.mdf;Integrated Security=True;User Instance=True";
SqlConnection conn = new SqlConnection(str);
SqlDataAdapter da = new SqlDataAdapter("select * from Table1", conn);
conn.Open();
da.SelectCommand.CommandText = "select * from Table1 where 帐号='" + User + " ' and 密码=' " + Pwd + " '";
DataSet ds = new DataSet();
int counts = da.Fill(ds, "Table1");
if (counts == 1)
{
Response.Redirect("Default4.aspx");
}
else
{
Label1.Text = "<script>alert('!!!&
楼上复制我的代码很无聊啊!
object obj = cmd.ExecuteScalar();//获得符合sql语句的第一行第一列的数据
if(obj ==null)
Label1.Text = "<script>alert('!!!')</script>";
else
Response.Redirect("Default4.aspx");