<?xml version="1.0" encoding="utf-8" ?> <codesnippets xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet"> <codesnippet format="1.0.0"> <header> <title>Delete Unique Record via Stored Procedure in SQL Server Database</title> <shortcut>deluniquesprocsql</shortcut> <description>Delete Unique Record via Stored Procedure in SQL Server Database</description> <author>C# .Net Fun - http://www.dotnetfun.com - Michael G.</author> </header> <snippet> <declarations> <literal> <id>intMyTableRecordID</id> <type>System.Int32</type> <tooltip>The unique integer identifier (primary key) for the MyTable table.</tooltip> <default>-1</default> </literal> <literal> <id>strConn</id> <type>System.String</type> <tooltip>Your SQL connection string.</tooltip> <default>"Data Source=HOSTNAME; User ID=userid; Password=password; Initial Catalog=Database;"</default> </literal> <literal> <id>strSProc</id> <type>System.String</type> <tooltip>Your Stored Procedure name string.</tooltip> <default>"sp_DeleteMyTableRecord"</default> </literal> <literal> <id>TableName</id> <type>System.String</type> <tooltip>The name of the DataSet table.</tooltip> <default>"MyTable"</default> </literal> </declarations> <code language="CSharp"> <![CDATA[ // NOTE: This code snippet is designed for VS.NET 2005 or later. // Make sure the following import directives are set: // using System.Data; // using System.Data.SqlClient; try { int intAffectedRecords = 0; using (SqlConnection sqlConn = new SqlConnection($strConn$)) { String strSProc = $strSProc$; int intMyTableRecordID = $intMyTableRecordID$; using (SqlCommand sqlCmd = new SqlCommand(strSProc, sqlConn)) { sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue("@MyTableRecordID", intMyTableRecordID); sqlConn.Open(); intAffectedRecords = sqlCmd.ExecuteNonQuery(); sqlConn.Close(); } } } catch (SqlException e) { throw e; } catch (Exception e) { throw e; } /* The Stored Procedure would look something like this: CREATE PROC sp_DeleteMyTableRecord @MyTableRecordID INT AS DELETE FROM MyTable WHERE MyTableRecordID = @MyTableRecordID; GO */ ]> </code> </snippet> </codesnippet> </codesnippets>