using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb;
using System.Data;
using System.Data.SqlClient;
public partial class KHDL : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
string id = TextBox1.Text;
string pasw = TextBox2.Text;
SqlConnection conn = new SqlConnection();
conn.ConnectionString = (@"Data Source=localhost;AttachDbFilename=E:\网站开发\数据库2\sql.mdf;Integrated Security=True");
conn.Open();
string strsql = "select [ClientID],[Status],[Password] from [Client]";
SqlCommand cmd = new SqlCommand(strsql, conn);
SqlDataReader rd = cmd.ExecuteReader();
rd.Read();
SqlDataAdapter sdaTest = new SqlDataAdapter("select * from Client where ClientID !='+TextBox1.Text+'", conn);
if (rd.HasRows)
{
Label1.Text = "没有账号请先注册";
}
else
{
SqlDataReader rd2 = cmd.ExecuteReader();
rd2.Read();
SqlDataAdapter sdaTest2 = new SqlDataAdapter("select * from Client where Password = '+TextBox2.Text+'", conn);
if (rd2.HasRows)
{
Label1.Text = "账号或者密码不正确。";
}
else
{
SqlDataReader rd3 = cmd.ExecuteReader();
rd3.Read();
SqlDataAdapter sdaTest3 = new SqlDataAdapter("select * from Client where Status='审核通过'", conn);
if (rd3.HasRows)
{
Response.Redirect("wdcy.aspx");
}
else
{
Label1.Text = "等待审核";
}
}
}
}
public string Password { get; set; }
}

求帮忙