string sqlconnstr = @"Data Source=.;Initial Catalog=sqltest;Integrated Security=True";
SqlConnection conn = new SqlConnection(sqlconnstr);
conn.Open();
SqlDataAdapter sda = new SqlDataAdapter("ado.procxiao", conn);
sda.SelectCommand.Parameters.AddWithValue("@name", txtuser.Text);
sda.SelectCommand.Parameters.AddWithValue("@npsw", txtpsw.Text);
DataSet ds = new DataSet();
sda.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
Response.Write("登陆成功!!");
Response.Redirect("Main.aspx");
}
else
{
Response.Write("登陆失败!!!");
}
conn.Close();
sda.Dispose();