对由sqldataadapter 存入dataset的数据进行筛选
string comd="select * from manager ";
SqlConnection conn=new SqlConnection();//建立连接
conn.open(); //打开连接
SqlDataAdapter da = new SqlDataAdapter(comd, conn);
DataSet ds = new DataSet();
da.Fill(ds,"Base_administrator_enter");
Countnumber = ds.Tables[0].Rows.Count;//记录列数
for (int i = 0; i < Countnumber; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
string Amount = dr["Administrators"].ToString();
if (Amount.Trim()=="eric")//注意一定要对获得的数据进行裁剪 Trim()
{
MessageBox.Show("success")
}
}