Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- string sqlIns = "INSERT INTO table (name, information, other) VALUES (@nome, @cognome, @datanascita, @indirizzo, @citta, @Cap, @Piva, @codfiscale, @dominio, @services)";
- db.Open();
- try
- {
- SqlCommand cmdIns = new SqlCommand(sqlIns, db.Connection);
- cmdIns.Parameters.Add("@nome", info);
- cmdIns.Parameters.Add("@cognome", info1);
- cmdIns.Parameters.Add("@datanascita", info2);
- cmdIns.Parameters.Add("@indirizzo", info3);
- cmdIns.Parameters.Add("@citta", info4);
- cmdIns.Parameters.Add("@Cap", info5);
- cmdIns.Parameters.Add("@Piva", info6);
- cmdIns.Parameters.Add("@codfiscale", info7);
- cmdIns.Parameters.Add("@dominio", info8);
- cmdIns.Parameters.Add("@services", info9);
- cmdIns.ExecuteNonQuery();
- cmdIns.Parameters.Clear();
- cmdIns.CommandText = "SELECT @@IDENTITY";
- // Get the last inserted id.
- int insertID = Convert.ToInt32( cmdIns.ExecuteScalar() );
- cmdIns.Dispose();
- cmdIns = null;
- }
- catch(Exception ex)
- {
- throw new Exception(ex.ToString(), ex);
- }
- finally
- {
- db.Close();
- }
Add Comment
Please, Sign In to add comment