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

Question

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...

Shrimant Telgave · 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.

Krutika Karekar · Answer

thank you sir...

Rajkiran Swain · Answer

SqlConnection connection = new SqlConnection( "YourDatabaseConnectionString" ); string sqlStatement = "DELETE FROM Customers WHERE CustomerID = @CustomerID" ; try { connection.Open(); SqlCommand cmd = new SqlCommand(sqlStatement, connection); cmd.Parameters.AddWithValue( "@CustomerID" , "SomeValueHere" ); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); } finally { connection.Close(); }