主要代码如下如下:
string constr = "server=localhost;User Id=root;password=;Database=bim_test";
MySqlConnection conn = new MySqlConnection(constr);//1.创建MySqlConnection对象
conn.Open();//2.打开
MySqlCommand cmd = new MySqlCommand("insert into t_family_infor values('Model','Window','800*1200')",conn);//3.创建Command请求对象
if (cmd.ExecuteNonQuery() > 0)//4.执行请求
{
Console.WriteLine("数据插入成功");
}