c#数据删除,插入,更新

最新推荐文章于 2024-09-19 11:19:05 发布

cqunknown

最新推荐文章于 2024-09-19 11:19:05 发布

阅读量526

点赞数

文章标签： c# textbox insert string cmd

本文链接：https://blog.csdn.net/cqunknown/article/details/2027615

版权

SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["connectionstring"].ToString();
string sqlstr = "insert into room values('" + textBox1.Text + "','" + textBox2.Text + "','" + richTextBox1.Text + "','0')";//可以是删除,插入,更新;

                SqlCommand cmd = new SqlCommand(sqlstr, conn);
                cmd.Connection.Open();
                cmd.ExecuteNonQuery();
                cmd.Connection.Close();
                MessageBox.Show("恭喜你，添加成功");