.net+链接+mysql_.net 链接MySql

String stringconnStr = String.Format("server={0};user id={1}; password={2}; database=test; pooling=false","localhost", "root", "123456");

MySqlConnection conn = new MySqlConnection(stringconnStr);

conn.Open();

String sql = "select * from stutbl";

//MySqlCommand command = new MySqlCommand(sql, conn); //创建 Command 对象

//MySqlDataReader reder = command.ExecuteReader();

//while (reder.Read())

//{

// //读出内容列

// string str = reder["user_name"].ToString();

// //读取分类列

// string str1 = reder["user_pass"].ToString();

// //分别为文本框加载数据

//}

MySqlDataAdapter da = new MySqlDataAdapter(sql, conn);

DataSet ds = new DataSet();//创建DataSet实例

da.Fill(ds, "testtabel");//使用DataAdapter的Fill方法(填充)，调用SELECT命令

DataTable tabel = ds.Tables["testtabel"];

foreach (DataRow drCurrent in tabel.Rows)

{

String aa = drCurrent["user_name"].ToString();

}

conn.Close();//关闭数据库