protected void Button_Click(object sender, EventArgs e)
{
string adi = txtAdi.Text;
string soyadi = txtSoyadi.Text;
string id = txtId.Text;
SqlConnection myConnection = new SqlConnection(Connection_String);
SqlTransaction myTransaction = null;
try
{
myConnection.Open();
myTransaction = myConnection.BeginTransaction();
SqlCommand myCommand = new SqlCommand();
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Connection = myConnection;
myCommand.CommandText = "insert_data_in_employee_table";
myCommand.Transaction = myTransaction;
SqlParameter Parameter1 = new SqlParameter("@adi", adi);
SqlParameter Parameter2 = new SqlParameter("@soyadi", soyadi);
SqlParameter Parameter3 = new SqlParameter("@id", id);
myCommand.Parameters.Add(Parameter1);
myCommand.Parameters.Add(Parameter2);
myCommand.Parameters.Add(Parameter3);
myCommand.ExecuteNonQuery();
myTransaction.Commit();
lblMsg.Text = "uygun mesajı siz yazın :)";
}
catch (SqlException ex)
{
myTransaction.Rollback();
lblMsg.Text = ""uygun mesajı siz yazın.. " + ex.Message;
}
finally
{
// Bağlantıyı Kapat.
if( myConnection.State == ConnectionState.Open )
{
myConnection.Close();
}
}
}