hoe to delete product

Question

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

Micke Blomqvist · Answer

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

Micke Blomqvist · 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!