2020-11-24

最新推荐文章于 2020-11-25 10:46:33 发布

力学术

最新推荐文章于 2020-11-25 10:46:33 发布

阅读量71

点赞数 1

分类专栏：笔记

本文链接：https://blog.csdn.net/yangxuhengli/article/details/110070338

版权

笔记专栏收录该内容

2 篇文章 0 订阅

订阅专栏

求求各位大佬看看，为什么数据一直写不进数据库？
private string myconnstr1 = @“server=localhost;User Id=root;password=yxh8367274466;Database=new_sch;Character set=utf8”;
private string mysqlstr1;
private MySqlConnection myconn1;
private MySqlDataAdapter mymda1;
private DataSet myds1 = new DataSet();
private void button1_Click(object sender, EventArgs e)
{
try
{
//录入成绩
myconn1 = new MySqlConnection(myconnstr1);
myconn1.Open();
MySqlCommand cm = new MySqlCommand();
cm.Connection = myconn1;
cm.CommandText= “insert into 学生信息(stunum,name,class,id）values(’”+ textBox1.Text.Trim() + “’,’”+ textBox2.Text.Trim() + “’,’”+ textBox3.Text.Trim() + “’,’”+ textBox4.Text.Trim() + “’)”;
MySqlDataAdapter da = new MySqlDataAdapter();
da.SelectCommand = cm;
DataSet ds = new DataSet();
da.Fill(ds);
myconn1.Close();
MessageBox.Show(“添加成功”, “提示”, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch
{
MessageBox.Show(“添加失败”, “提示”, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}