用DataReader类处理登录表单
private void buttonLogOn_Click(object sender, System.EventArgse)
{
stringuserName=textBoxUser.Text;
stringuserPassword=textBoxPW.Text;
stringconnectionString="workstation id=localhost;initialcatalog=CommuList;user id=sa; pwd=";
SqlConnection myConnection=newSqlConnection(connectionString);
SqlCommandmyCommand=myConnection.CreateCommand();
stringcommandString="select * from Users
whereUserId='"+userName+"' and PassWord='"+userPassword+"'";
myCommand.CommandText=commandString;
DataSetmyDataSet=new DataSet();
SqlDataAdapter myAdapter=new SqlDataAdapter();
myAdapter.SelectCommand=myCommand;
myConnection.Open();
intn=myAdapter.Fill(myDataSet,"Users");
if(n==0)
{
MessageBox.Show("用户名或密码错误,请重新输入!");
textBoxUser.Text="";
textBoxPW.Text="";
textBoxUser.Focus();
}
else
{
MessageBox.Show("恭喜您可以成功登陆!");
this.Close();
}
}
在通常情况下,DataSet与DataReader可能可以相互代替,当有特定要求时却需要仔细分析,到底使用哪种方式更合适。