目的:选出符合条件的数据
详细代码:
string sqlconst = "server=localhost;user=root;database=mytestsql;port=3306;password=root;";
MySqlConnection connect = new MySqlConnection(sqlconst);
connect.Open();
Console.WriteLine("成功链接mysql...");
MySqlCommand command = new MySqlCommand("select * from testuserid", connect);
MySqlDataReader reader = command.ExecuteReader();
try
{
while (reader.Read())
{
if (reader.HasRows)
{
Console.WriteLine("testuserid=" + reader.GetInt32(0) + "/testint=" + reader.GetInt32(1));
}
}
}
catch (Exception ex)
{
Console.WriteLine("查询失败...");
}
finally
{
reader.Close();
}