c#连接mysql

MySqlConnection conn = new MySqlConnection("User Id=root;PassWord=sa;Host=localhost;Database=mis;");
conn.Open();
MySqlDataAdapter da = new MySqlDataAdapter("select id, name, age from `mis`.`users` ",conn);
DataSet ds = new DataSet();
da.Fill(ds,"users");
conn.Close();
DataGrid1.DataSource= ds;
DataGrid1.DataBind();

posted @ 2012-01-07 22:58  刘振明  阅读(306)  评论(0)    收藏  举报