SqlConnection myConnection = new SqlConnection("data Source=(local);uid=sa; pwd=110220;database=Myweb");
string cmdText;
cmdText="select * from admin where Admin_user='" + UserName.Text + "' and Admin_password='" + PassWord.Text+"'";
SqlCommand cmd=new SqlCommand(cmdText,myConnection); 
myConnection.Open();
if (UserName.Text==myConnection.Database.GetType(Admin_name) && PassWord.Text==myConnection.Database.GetType=(Admin_password) )
{
Server.Transfer("Register.aspx");
}
else
{
Label1.Text="密码不正确";
}
try{cmd.ExecuteNonQuery();}
catch{Label1.Text="出错";}
finally{myConnection.Close();}