how to delete record from sql database in asp.netc# ?

Krutika Karekar

8y733

hello ....i created submit button for inserting values...but i also need delete button

...so plz tell me how to delete records on clicking button...

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shrimant Telgave8y ago
Accepted answer
Step-1:   Create table having name like Product containing two column "PId" and "ProductName". You can take column as many as you want. but I am taking only two for demo.

Step-2: Create web form/Winform application and add controlrs as per requirement.
              Add one TextBox which carry the product id.
            Add one button having name like "Delete". Double click on button.

Step-3: Code base changes write the following code.
           string connectionString = ConfigurationManager.ConnectionStrings["connectionString"].ToString();
           using (SqlConnection con = new SqlConnection(connectionString))
           {
               using (SqlCommand cmd = new SqlCommand(@"Delete from Product
                                                    Where PId = @ID", con))
               {
                   con.Open();
                   cmd.Parameters.AddWithValue("@ID", productId);
                   cmd.ExecuteNonQuery();
                   con.Close();
               }
           }

I hope this will help you to achieve your functionaliy.
Thanks.
0
Krutika Karekar8y ago
thank you sir...
0
Rajkiran Swain8y ago
1. SqlConnection connection = new SqlConnection("YourDatabaseConnectionString");
3. string sqlStatement = "DELETE FROM Customers WHERE CustomerID = @CustomerID";
5. try{
6. connection.Open();
7. SqlCommand cmd = new SqlCommand(sqlStatement, connection);
8. cmd.Parameters.AddWithValue("@CustomerID", "SomeValueHere");
9. cmd.CommandType = CommandType.Text;
10. cmd.ExecuteNonQuery();
12. }
13. finally {
14. connection.Close();
15. }
0