62,047
社区成员
发帖
与我相关
我的任务
分享
protected void Button5_Click(object sender, EventArgs e)
{
SqlConnection MyConnection;
SqlCommand MyCommond;
SqlDataReader MyDataReader;
int iNum;
MyConnection = new SqlConnection();
MyConnection.ConnectionString = "server=(local);user id=sa;pwd=;database=AndXu";
MyConnection.Open();
MyCommond = new SqlCommand();
MyCommond.CommandText = "select * from UserInfo where [UserName]= @name and [UserSex]= @sex " ; //这句新修改的
MyCommond.CommandType = CommandType.Text;
MyCommond.Connection = MyConnection;
MyCommond.Parameters.Add("@name",Name.Text); //从这里设置关联
MyCommond.Parameters.Add("@sex",Sex.Text);
MyDataReader = MyCommond.ExecuteReader();
while (MyDataReader.Read())
{
for (int inum = 0; inum < MyDataReader.FieldCount; inum++)
{
AllSult.Text = MyDataReader[0].ToString()
+ MyDataReader[1].ToString()
+ MyDataReader[2].ToString()
+ MyDataReader[3].ToString();
}
}
MyDataReader.Close(); //Copy and don't know y.
MyConnection.Close();
}
MyCommond.CommandText = "select * from UserInfo where [UserName]= @username and [UserSex]= @usersex " ; //这句新修改的
MyCommond.CommandType = CommandType.Text;
MyCommond.Connection = MyConnection;
MyCommond.Parameters.Add("@username",Name.Text); //从这里设置关联
MyCommond.Parameters.Add("@usersex",Sex.Text);
MyCommond.CommandText = "select * from UserInfo where [UserName]= @name and [UserSex]= @sex " ;
MyCommond.CommandText = "select * from UserInfo where [UserName]= "+@name+" and [UserSex]= "+@sex+" " ;
while (MyDataReader.Read())
{
AllSult.Text += MyDataReader[0].ToString()
+ MyDataReader[1].ToString()
+ MyDataReader[2].ToString()
+ MyDataReader[3].ToString();
}