How to get last inserted ID in MessageBox after clicking Submit Button

Question

I have this code:

private void btnPotvrdi_Click(object sender, EventArgs e)
{
     SqlConnection con = new SqlConnection("Data Source=BCKPSRVR;Initial Catalog=protokol;Integrated Security=True");
     con.Open();
     SqlCommand sc = new SqlCommand("insert into Knjiga (Datum_prijema, Predmet, Posiljalac, Adresa_posiljaoca, Primaoc, Datum_proslijeda)  values ('" + dateTimePicker1.Value.ToString("yyyy-MM-dd") + "','" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + dateTimePicker2.Value.ToString("yyyy-MM-dd") + "');", con);
     int o=sc.ExecuteNonQuery();
     MessageBox.Show(o + " :Podaci su unešeni");
     con.Close();
}

When I insert into this table, I have an auto_increment int primary key column called Osnovni_br. How can i get the last value of that column (Osnovni_br) in MessageBox or insted of MessageBox?

Beware of Sql injection. You can append `SELECT SCOPE_IDENTITY();` to your query and use `ExecuteScalar()`, note that it returns a decimal value. I assumed `MSSQL` for no good reason. — Silvermind, Apr 10 '14 at 06:53

Naveed Quadri · Answer 1 · 2014-04-10T08:13:55.920

0

//read about sql injection here http://www.codeproject.com/Articles/11020/SQL-injection-attacks
using (var conn = new SqlCeConnection("Data Source=BCKPSRVR;Initial Catalog=protokol;Integrated Security=True"))
      {
          conn.Open();
          using (var cmd = new SqlCeCommand())
          {
              cmd.Connection = conn;
              cmd.CommandText = "insert into Knjiga (Datum_prijema, Predmet, Posiljalac, Adresa_posiljaoca, Primaoc, Datum_proslijeda)  values (@Datum_prijema,@Predmet,@Posiljalac,@Adresa_posiljaoca,@Primaoc,@Datum_proslijeda);SELECT CAST(scope_identity() AS int)";
              cmd.Parameters.AddWithValue("Datum_prijema", dateTimePicker1.Value.ToString("yyyy-MM-dd"));
              //.... similarly add other values
              int id = (int)cmd.ExecuteScalar();
          }
      }

edited Apr 10 '14 at 08:13

answered Apr 10 '14 at 07:21

Naveed Quadri

498
5
18

I got this error [PHOTO OF THE ERROR](http://s7.postimg.org/m3nfy683v/error.jpg) – Mladen G Apr 10 '14 at 08:01
there was a duplicate in parameter values.. corrected it. – Naveed Quadri Apr 10 '14 at 08:15
I did, still the same. Caught: "Incorrect syntax near ','." – Mladen G Apr 10 '14 at 08:18
OK i got it. But what I also wanted is when I insert all that to open a small windows showing me the last ID value. – Mladen G Apr 10 '14 at 08:23

How to get last inserted ID in MessageBox after clicking Submit Button

1 Answers1