C#

protected void btnAdd_Client(object sender, System.EventArgs e)
        {
            SqlConnection con = new SqlConnection(@"Data Source=JOHN-PC\SQLEXPRESS;Initial Catalog=subiect1;Integrated Security=True");
            try
            {
                con.Open();
                SqlCommand command = new SqlCommand("SET IDENTITY_INSERT Clienti ON");
                command.ExecuteNonQuery();
                SqlCommand cmd = new SqlCommand("insert into Clienti(ID, Nume, Prenume, Data_Nasterii, Adresa_mail) values(@ID, <a href="/Members/nume">@Nume</a> @Prenume, @Data_Nasterii, @Adresa_mail)", con);
                cmd.Parameters.AddWithValue("@ID", txtID.Text);
                cmd.Parameters.AddWithValue("@Nume", txtNume.Text);
                cmd.Parameters.AddWithValue("@Prenume", txtPrenume.Text);
                cmd.Parameters.AddWithValue("@Data_Nasterii", txtDataNastere.Text);
                cmd.Parameters.AddWithValue("@Adresa_mail", txtAdresamail.Text);

                int count = cmd.ExecuteNonQuery();
                if (count == 1)
                    lblMsg.Text = "Clientul [" + txtID.Text + "] a fost adaugat!";
                else
                    lblMsg.Text = "Clientul nu a putut fi adaugat!";
            }
            catch (Exception ex)
            {
                lblMsg.Text = "Error --> " + ex.Message;
            }
            finally
            {
                SqlCommand command = new SqlCommand("SET IDENTITY_INSERT Clienti OFF");
                command.ExecuteNonQuery();
                con.Close();
            }
        }