Simple C# program with ADO.NET

Posted on: 13/11/2012 13/11/2012
Categories: ADO.NET, C# Console Programs, C#.Net

In this post i am posting a simple C# console program to start with ADO.NET. This may help the beginners in understanding the insertion of data into a database from a C# program.

Before going for the program create a table in sql server using the following command:

CREATE TABLE EMP_DETAILS(EMP_ID INT,EMP_NAME VARCHAR(25))

1	CREATE TABLE EMP_DETAILS(EMP_ID INT,EMP_NAME VARCHAR(25))

Now I am writing a C# program to insert data into the table EMP_DETAILS..

using System;
using System.Data.SqlClient; //Namespace for connecting to sql server

namespace First_DataBase_Program
{
    class Program
    {
        static void Main(string[] args)
        {
            SqlConnection con = new SqlConnection();
            SqlCommand cmd = new SqlCommand();
            //if u r using windows authentication for sql server then ConnectionString is
            con.ConnectionString = "Data Source=LocalHost;Integrated Security=true;Initial Catalog=sameer";
            /*if u r using sql authenticaton for sql server then ConectionString is
            con.ConnectionString = "Data Source=LocalHost;Initial Catalog=<database name>;user id=<user name>;password=<password>";
            */

            int Emp_Id = 0;
            string Emp_Name = "", option = "Y";
            Console.WriteLine(">> Simple C# Console Program to Start with ADO.NET<<");
            try
            {
                do
                {
                    if (option != "Y"&& option != "y"&& option != "N"&& option != "n")
                    {
                        Console.Write("Press Y to continue and N to exit : ");
                        option = Console.ReadLine();
                    }
                    else
                    {
                        Console.Write("\n Enter employee id:");
                        Emp_Id = Convert.ToInt32(Console.ReadLine());
                        Console.Write("\n Enter Employee Name:");
                        Emp_Name = Console.ReadLine();
                        cmd.CommandText = "INSERT INTO Emp_Details VALUES(" + Emp_Id + ",'" + Emp_Name + "')";
                        cmd.Connection = con;
                        con.Open();
                        cmd.ExecuteNonQuery();
                        con.Close();
                        Console.WriteLine("\n Command is:" + cmd.CommandText + "\n Record Inserted successfully");
                    }
                    Console.Write("\n Press Y to continue and N to exit : ");
                    option = Console.ReadLine();
                } while (option != "N" || option == "n");

                Console.ReadLine();
            }
            catch (Exceptionex)
            {
                //Console.WriteLine("\n Error Occured...Try Again");
                Console.Write(ex.Message);
                Console.ReadLine();
            }
        }
    }
}

using System;

using System.Data.SqlClient; //Namespace for connecting to sql server

namespace First_DataBase_Program

{

class Program

{

static void Main(string[] args)

{

SqlConnection con = new SqlConnection();

SqlCommand cmd = new SqlCommand();

//if u r using windows authentication for sql server then ConnectionString is

con.ConnectionString = "Data Source=LocalHost;Integrated Security=true;Initial Catalog=sameer";

/*if u r using sql authenticaton for sql server then ConectionString is

con.ConnectionString = "Data Source=LocalHost;Initial Catalog=<database name>;user id=<user name>;password=<password>";

int Emp_Id = 0;

string Emp_Name = "", option = "Y";

Console.WriteLine(">> Simple C# Console Program to Start with ADO.NET<<");

try

{

if (option != "Y"&& option != "y"&& option != "N"&& option != "n")

{

Console.Write("Press Y to continue and N to exit : ");

option = Console.ReadLine();

}

else

{

Console.Write("\n Enter employee id:");

Emp_Id = Convert.ToInt32(Console.ReadLine());

Console.Write("\n Enter Employee Name:");

Emp_Name = Console.ReadLine();

cmd.CommandText = "INSERT INTO Emp_Details VALUES(" + Emp_Id + ",'" + Emp_Name + "')";

cmd.Connection = con;

con.Open();

cmd.ExecuteNonQuery();

con.Close();

Console.WriteLine("\n Command is:" + cmd.CommandText + "\n Record Inserted successfully");

}

Console.Write("\n Press Y to continue and N to exit : ");

option = Console.ReadLine();

} while (option != "N" || option == "n");

Console.ReadLine();

}

catch (Exceptionex)

{

//Console.WriteLine("\n Error Occured...Try Again");

Console.Write(ex.Message);

Console.ReadLine();

}

Execute the program to insert the records in the table EMP_DETAILS. The sample output is given below.

csharp-first-database-program_output

Now open the sql server and type the following command and execute.

SELECT * FROM EMP_DETAILS

1	SELECT * FROM EMP_DETAILS

Then u can see the inserted records in the table EMP_DETAILS as shown below.

Sameer Shaik

184

3 thoughts on “Simple C# program with ADO.NET”

Simple Example to Start With ADO.NET in Windows C# « DotNet Dots says:

15/08/2013 at 9:37 pm

[…] previous posts we have seen CONNECTING WITH SQL SERVER USING ADO.NET , Simple C# program with ADO.NET […]
harish kumar reddy says:

15/08/2013 at 9:37 pm

plz update me new issues in dot net……………….!
harish kumar reddy says:

15/08/2013 at 9:37 pm

hay very nice ra wel don programmer………………….!

Comments are closed.