<?xml version="1.0" encoding="utf-8" ?> <codesnippets xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet"> <codesnippet format="1.0.0"> <header> <title>Add Record via Stored Procedure to SQL Server Database</title> <shortcut>addsprocsql</shortcut> <description>Add Record via Stored Procedure to SQL Server Database</description> <author>C# .Net Fun - http://www.dotnetfun.com - Michael G.</author> </header> <snippet> <declarations> <literal> <id>strCol1</id> <type>System.String</type> <tooltip>The string to be saved in the Col1 column of the MyTable table.</tooltip> <default>"Hello World!"</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_AddMyTableRecord"</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$; String strCol1 = $strCol1$; using (SqlCommand sqlCmd = new SqlCommand(strSProc, sqlConn)) { sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue("@Col1", strCol1); 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_AddMyTableRecord @Col1 VARCHAR(255) = NULL AS INSERT INTO MyTable (Col1) VALUES (@Col1); GO */ ]> </code> </snippet> </codesnippet> </codesnippets>