C# – Sql Parameters – Insert Statement

C# – Sql Parameters Source Code – Insert Statement

Purpose: – Illustrates using Sql Parameters with Insert Statement.
Prerequistes:

1. Install C# (Express or Standard Edition)
2. Install SQL Server Express
3. Download Northwind Database
4. Attach Northwind Database to Databases in Sql Express

Notes:

• Console Application is used to simplify things, but Windows Forms or Web Forms could also be used
• You can build a library of syntax examples by using same project over and over and just commenting out what you do not want to execute in Program.cs

Instructions:

1. Use C# 2008 (Express or Standard) Edition
2. Create new project; select Console Application; name of Project could be CSharp_Syntax.
3. Right-click project name in solution explorer; add new folder; name of folder could be DatabaseADONET
4. Right-click folder; add class; class name could be clsSqlParametersInsert.cs
5. Copy code into clsSqlParametersInsert.cs
6. Copy code into Program.cs
7. Click green arrow to start with debugging

Step 1: Use View Plain to Cut-n-paste code into clsSqlParametersInsert.cs

 C# | 
 copy code |
?
 
using System;
using System.Data;
using System.Data.SqlClient;
 
class clsSqlParametersInsert
{
 
    public  void Main()
    {
        SqlConnection thisConnection = new SqlConnection("server=.\\SQLEXPRESS;" + "integrated security=sspi;database=Northwind");
 
        //Create Command object
        SqlCommand nonqueryCommand = thisConnection.CreateCommand();
 
        try
        {
            // Open Connection
            thisConnection.Open();
            Console.WriteLine("Connection Opened");
 
            // Create INSERT statement with named parameters
            nonqueryCommand.CommandText = "INSERT  INTO Employees (FirstName, LastName) VALUES (@FirstName, @LastName)";
 
            // Add Parameters to Command Parameters collection
            nonqueryCommand.Parameters.Add("@FirstName", SqlDbType.VarChar, 10);
            nonqueryCommand.Parameters.Add("@LastName", SqlDbType.VarChar, 20);
 
            // Prepare command for repeated execution
            nonqueryCommand.Prepare();
 
            // Data to be inserted
            string[] names = { "Wade", "David", "Charlie" };
            for (int i = 0; i < = 2; i++)
            {
                nonqueryCommand.Parameters["@FirstName"].Value = names[i];
                nonqueryCommand.Parameters["@LastName"].Value = names[i];
 
                Console.WriteLine("Executing {0}", nonqueryCommand.CommandText);
                Console.WriteLine("Number of rows affected : {0}", nonqueryCommand.ExecuteNonQuery());
            }
        }
        catch (SqlException ex)
        {
            // Display error
            Console.WriteLine("Error: " + ex.ToString());
        }
        finally
        {
            // Close Connection
            thisConnection.Close();
            Console.WriteLine("Connection Closed");
 
        }
 
        Console.ReadLine();
 
    }
 
}
 
 

 C# | 
 copy code |
?
 
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
 
namespace CSharp_Syntax
{
    class Program
    {
        static void Main(string[] args)
        {
            //DatabaseADONET
 
            clsSqlParametersInsert mySqlParametersInsert = new clsSqlParametersInsert();
            mySqlParametersInsert.Main();
 
 
        }
    }
}
 

Related posts:

1. VB.NET Sql Parameters Source Code – Insert Statement Source code example that illustrates using SQL parameters with insert...
2. C#: SqlConnection Connection String C# SqlConnection Connection String Source code example with InfoMessage....

Related posts brought to you by Yet Another Related Posts Plugin.