C#通过MySqlHelper进行多条数据查询

1.准备好连接字段
string ip = “127.0.0.1”；
string user = “root”;
string password = “1234“;
string port = ”3306“;

string connectionString = “server=” + ip + “;” + “uid=” + user + “;” + “password=” + password + “;” + “database=” + “parking” + “;” + “charset=utf8;”;

2.类型
CommandType cmdType = CommandType.Text;

3.sql语句
string sqlInPark = string.Format(@”select a from table where c = ‘{0}’”, “1”);

4.MySqlParameter[]
MySqlParameter[] parameters = {new MySqlParameter(“@a”, MySqlDbType.VarChar, 20)};

5.MySqlDataReader
MySqlDataReader drReader = MySqlHelper.ExecuteReader(connectionString, cmdType, sqlInPark, parameters);

6.Read(获取查询的数据)
while(drReader.Read())
{
// 对所获取到的数据进行操作
}