vs2008 c# 对sql插入操作

最新推荐文章于 2017-11-04 16:19:58 发布

ladder_of_love

最新推荐文章于 2017-11-04 16:19:58 发布

阅读量4.7k

点赞数

分类专栏： C++

本文链接：https://blog.csdn.net/ouchengguo/article/details/8180548

版权

C++ 专栏收录该内容

32 篇文章 0 订阅

订阅专栏

private void button1_Click(object sender, EventArgs e)
        {
            string sqlCon = "server=(local);uid=sa;pwd=sa;database =Store";
            string sql = "Insert into  GoodsTable(GoodsNumber, GoodsName,GoodsType)Values( '" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "')";
            SqlConnection conn = new SqlConnection(sqlCon);
            SqlCommand cmd = new SqlCommand(sqlCon, conn);
            //cmd.CommandText =sql;
            //cmd.Connection=conn.Connection;
            conn.Open();
            int val = cmd.ExecuteNonQuery();
            if (val >= 1)
            {
                MessageBox.Show("添加成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                MessageBox.Show("请正确输入！", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
            conn.Close();

        }