I just need a solution for insertion and deletion of data together on button -click event . On click of button the record should be deleted
and deleted record should be added to another table .How do you do this using ado.net and sql server without data access layer.
protected void Delete_button_Click(object sender, EventArgs e)
{
string ConnectionString = ConfigurationManager.ConnectionStrings["PizzaDelievery"].ConnectionString;
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
String strQuery = "Delete from Drivers where ID =@ID";
SqlCommand cmd = new SqlCommand();
cmd.Parameters.AddWithValue("@ID", Driver_Namedropdwn.SelectedItem.Value);
cmd.CommandType = CommandType.Text;
cmd.CommandText = strQuery;
connection.Open();
cmd.Connection = connection;
cmd.ExecuteNonQuery();
Lblstatus.Visible = true;
Lblstatus.Text = "Successfully Deleted";
Driver_FirstName.Text = "";
Driver_LastName.Text = "";
Driver_License.Text = "";
Driver_Namedropdwn.SelectedIndex = 0;
}
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
SqlCommand cmd = connection.CreateCommand();
connection.Open();
cmd.CommandText = "insert into Driver_Deleted values('" + Driver_ID.Text + "','" + Driver_FirstName.Text + "','" + Driver_LastName.Text + "','" + Driver_License.Text + "')";
cmd.ExecuteNonQuery();
//SqlCommand cmd = new SqlCommand("spAddDeletedDrivers", connection);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@ID", Driver_ID.Text);
//cmd.Parameters.AddWithValue("@DriverFirstName", Driver_FirstName.Text);
//cmd.Parameters.AddWithValue("@DriverLastName", Driver_LastName.Text);
//cmd.Parameters.AddWithValue("@DriverActiveLicense", Driver_License.Text);
//connection.Open();
// cmd.ExecuteNonQuery();
}}