110,536
社区成员
发帖
与我相关
我的任务
分享
string connString = "server=localhost;port=3306;user id=root;persistsecurityinfo=False;database=northcerp;password=xxxx;Convert Zero Datetime=True;Allow Zero Datetime=True;CharSet=utf8";
string sql = "select * from BA_Shop";
MySqlConnection conn = new MySqlConnection(connString);
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
sda = new MySqlDataAdapter(cmd);
MySqlCommandBuilder scb = new MySqlCommandBuilder(sda);
DataTable dt = new DataTable();
sda.Fill(dt);
this.dataGridView1.DataSource = dt;