How to insert data into SQL Server?

Question

I have code like this:

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();

Please help me to inside int to my table Paket.

You might want to read this and replace the calls to AddWithValue(name,value) with Add(name, sqlDbType).Value = value. — juharr
– juharr, Commented Jan 16, 2016 at 11:16
You should check out Can we stop using AddWithValue() already? and stop using .AddWithValue() - it can lead to unexpected and surprising results... — marc_s
– marc_s, Commented Jan 16, 2016 at 11:35

Pரதீப் · Accepted Answer · 2016-01-16 10:46:41Z

3

There is a missing parenthesis at the end of Insert query

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

edited Jan 16, 2016 at 10:46

answered Jan 16, 2016 at 10:43

Pரதீப்

94.1k21 gold badges144 silver badges179 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Antoni Angga Over a year ago

Oh my god i forget to change it, Thanks sir :D

jdweng · Accepted Answer · 2016-01-16 11:10:13Z

0

Try this

           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();

edited Jan 16, 2016 at 11:10

answered Jan 16, 2016 at 10:48

jdweng

34.5k3 gold badges17 silver badges19 bronze badges

1 Comment

Gottfried Lesigang Over a year ago

Your third line is missing the closing paranthesis after the value - as the OP did :-)

Collectives™ on Stack Overflow

How to insert data into SQL Server?

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related