MySql.Data.MySqlClient方法连接mysql以及使用

mysqlCommand 方法

public static string connstr = "User Id=root;pwd= ;Host=localhost;Port=3306;Database=textbooks;Character Set=utf8";

MysqlConnection conn=MysqlConnection(connstr);

MysqlCommand command=new MysqlCommand(sql,conn);

ExecuteScalar：   command.ExecuteScalar();返回object,是否有数据

ExecuteReader:   command.ExecuteReader();返回MySqlDataReader类型mySqlRdr对象;

获取值

while (mySqlRdr.Read())
{
Console.WriteLine(mySqlRdr.GetString(0));

}

MySqlDataAdapter查询方法

MySqlDataAdapter adr=new MySqlDataAdapter(sql,conn);//不用command

DataSet T = new DataSet();
adr.Fill(T,"table1");
//this.dataGridView1.DataSource = ds.Tables["table1"];

DataTableReader dtr = T.CreateDataReader();

while (dtr.Read())
{

Console.WriteLine(dtr[0] + "###" + dtr.GetValue(1));

}