如何将数据插入 SQL Server

本文关键字：SQL Server 插入 数据 | 更新日期: 2023-09-27 18:30:46

我有这样的代码：

con.Open();
cmd = new SqlCommand("insert into Penawaran (ID_Paket,Jenis_Paket,Harga_Paket) Values (@ID_Paket,@Jenis_Paket,@Harga_Paket", con);
cmd.Parameters.AddWithValue("@ID_Paket", txtIDPaket.Text);
cmd.Parameters.AddWithValue("@Jenis_Paket", txtjenisPaket.Text);
cmd.Parameters.AddWithValue("@Harga_Paket", txtHargaPaket.Value); // this is int sir how to insert it, still error i write like this
cmd.ExecuteNonQuery();
con.Close();

请帮我把里面的 int 放到我的桌子上Paket。

如何将数据插入 SQL Server

查询末尾缺少括号Insert

 INSERT INTO Penawaran (ID_Paket,Jenis_Paket,Harga_Paket)
               VALUES (@ID_Paket,@Jenis_Paket,@Harga_Paket) --Here

试试这个

           SqlConnection con = new SqlConnection();
            con.Open();
            SqlCommand cmd = new SqlCommand("insert into Penawaran (ID_Paket,Jenis_Paket,Harga_Paket) Values (@ID_Paket,@Jenis_Paket,@Harga_Paket", con));
            cmd.Parameters.Add("@ID_Paket", SqlDbType.Int);
            cmd.Parameters.Add("@Jenis_Paket", SqlDbType.VarChar);
            cmd.Parameters.Add("@Harga_Paket", SqlDbType.VarChar); // this is int sir how to insert it, still error i write like this
            cmd.Parameters["@ID_Paket"] = int.Parse(txtIDPaket.Text);
            cmd.Parameters["@Jenis_Paket"] = txtjenisPaket.Text;
            cmd.Parameters["@Harga_Paket"]  = txtHargaPaket.Value; // this is int sir how to insert it, still error i write like this
            cmd.ExecuteNonQuery();
            con.Close();
相关文章：