string connectStr = "server=127.0.0.1;port=3306;database=dgl06;user=root;password=Administrator";//本机配置
MySqlConnection conn = new MySqlConnection(connectStr);
try
{
conn.Open();//开启数据库
Console.WriteLine("已连接。。");
string sql = "insert into name(name,memo,opens) values('" + textEdit1.EditValue + "','zxw'," + comboBoxEdit1.EditValue + ")";//当前时间
MySqlCommand cmd = new MySqlCommand(sql, conn);
int result = cmd.ExecuteNonQuery();//返回值受数据库中数据的行数影响
Console.WriteLine("插入完成");
MySqlDataAdapter dataDB = new MySqlDataAdapter(sql, conn);
DataSet data = new DataSet1();
dataDB.Fill(data);
}
catch
{
Console.WriteLine(e.ToString());
}