Inserte Data Using SQL Statements : Insert « Database ADO.net « C# / C Sharp






  1. C# / C Sharp
  2. Database ADO.net
  3. Insert

Inserte Data Using SQL Statements


/*
 * C# Programmers Pocket Consultant
 * Author: Gregory S. MacBeth
 * Email: gmacbeth@comporium.net
 * Create Date: June 27, 2003
 * Last Modified Date:
 * Version: 1
 */
using System;
using System.Data;
using System.Data.SqlClient;

namespace Client.Chapter_13___ADO.NET
{
    
    public class InsertingDataUsingSQLStatements
    {
        static void Main(string[] args)
        {
            SqlConnection MyConnection = new SqlConnection(@"Data Source=(local); Initial Catalog = CaseManager; Integrated Security=true");

            MyConnection.Open();

            String MyString = @"INSERT INTO Test(ID, Contact, Email) VALUES(2, 'Greg', 'MacBeth')";
            SqlCommand MyCmd = new SqlCommand(MyString, MyConnection);

            MyCmd.ExecuteScalar();
            MyConnection.Close();
        }
    }
}








Related examples in the same category

1.Use SQL command to insert data into database table
2.Bind parameters to insert command
3.Run an INSERT statement with parameters
4.Insert Data Using SqlCommandBuilder