Setup Packet for WPF Project

Add data into SQL Management Studio Database with the help of C#

New Query >>

CREATE TABLE TABLE_NAME
(
FirstName varchar(255),
LastName varchar(255),
);



C# >>

using System;

using System.Data.SqlClient;

namespace SQLConnection

{

    class Program

    {

        static void Main()

        {

            SqlConnection conn = new SqlConnection(
                                 "Server=PC_NAME\\SQLEXPRESS; Database=TestDB; Integrated Security=true");

            conn.Open();

            SqlCommand cmd = new SqlCommand(
                             "insert into TABLE_NAME (LastName, FirstName) values('Shirakatsi','Anania');", conn);

            cmd.ExecuteNonQuery();

            Console.WriteLine("Inserting Data Successfully");

            conn.Close();

            Console.ReadKey();

        }

    }

}