hoe to delete product

Question

how to delete product code in Sql Data Base please tel me the Sq l Query

Micke Blomquist · Answer

Did I answer your question? Please mark as answered so others can learn from it as well. Thank you!

Micke Blomquist · Answer

First create a SQL stored procedure for the actual deletion: CREATE PROCEDURE [dbo] . [delete_productcode] @ProductCode varchar ( 50 ) AS BEGIN delete from product_table where productcode = @ProductCode END This assumes that the SQL Server table is named product_table and that the column holding the productcode is named productcode Then you need to call this procedure from C# code. First add the following using statement at the top in your class: using System.Data; using System.Data.SqlClient; Then call the stored prodcedure: // Here you need to assing your productcode that you want to delete perhaps from a textbox string productcode = assign the productcode to this variable; // A connectionstring for you database string connectionstring =  Data Source=your_machine_name;Initial Catalog=your_database;User Id=your_user;Password=your_pwd; ; using ( SqlConnection c = new SqlConnection (connectionstring)) { // Create a command with the stored procedure name and the SQL Server connection object SqlCommand cmd = new SqlCommand ( delete_productcode  c); cmd.CommandType = CommandType .StoredProcedure; // Assign the parameter to the stored procedure cmd.Parameters.AddWithValue( @ProductCode  productcode); c.Open(); // Execute the stored procedure cmd.ExecuteNonQuery(); c.Close(); } That's it!