TECHASHUS - SIMPLE SQL SERVER C# CONNECTIVITY CODE

SIMPLE SQL SERVER C# CONNECTIVITY CODE

using System.Data.SqlClient;                       

namespace Sample  

{

   public partial class Form1 : Form

   {

     SqlConnection con = new SqlConnection(@”Connection String”);//Database Connection String

     SqlCommand cmd = new SqlCommand();

        public Form1()

        {

            InitializeComponent();

        }

IN FORM LOAD INITIALIZE THE CONNECTION AND CALL disp_data() METHOD FOR INSERTED DATA SHOWN WHEN PAGE LOAD

     private void Form1_Load(object sender, EventArgs e)

        {

            cmd.Connection = con;

            disp_data();

        }

CODE FOR SAVING THE DATA HERE ALSO disp_data() METHOD CALLED FOR INSERTED ROW CAN BE SHOWN WHEN THE CLICK EVENT ACCURED.TRY CATCH BLOCK FOR HANDLING EXEPTIONS

     private void btnSave_Click(object sender, EventArgs e)

        {

            try

            {

            con.Open();

            cmd.CommandText = "insert into Tbl_FinProj values('"+ txtProductID.Text +"','"+dateTimePicker2.Text.ToString()+"')";

            cmd.ExecuteNonQuery();

            con.Close();

            disp_data();

            MessageBox.Show("inserted successfully");

            }

        catch(Exception ex)

            {

                MessageBox.Show(ex.Message);

            }

         }

METHOD DEFENITION FOR DISPLAYING THE DATA IN GRIDVIEW WHEN CLICK AND FORM LOAD.

        private void disp_data()

        {

            try

            {

            con.Open();

            cmd.CommandText="select * from Tbl_FinProj ";

            cmd.ExecuteNonQuery();

            SqlDataAdapter da=new SqlDataAdapter(cmd);

            DataTable dt=new DataTable();

            da.Fill(dt);

            dataGridView1.DataSource=dt;

            con.Close();

            }

            catch(Exception ex)

            {

                MessageBox.Show(ex.Message);

            }

         }

    }

}

SIMPLE SQL SERVER C# CONNECTIVITY CODE

Imports Sysyem.Data.SqlClient                

Public Class Sample

    Dim con As New SqlConnection("Connection String")

    Dim cmd As New SqlCommand

IN FORM LOAD INITIALIZE THE CONNECTION AND CALL disp_data() METHOD FOR INSERTED DATA SHOWN WHEN PAGE LOAD

Private Sub Sample(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

    cmd.connection=con

    disp_data()

End Sub

CODE FOR SAVING THE DATA HERE ALSO disp_data() METHOD CALLED FOR INSERTED ROW CAN BE SHOWN WHEN THE CLICK EVENT ACCURED.

Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click

    con.open()

    cmd.commandtext="insert into Tbl_FinProj values('"+ txtProductID.Text +"')"

    cmd.ExecuteNonQuery()

    con.close()

    textbox1.text=""

    MessageBox.Show("inserted successfully")

    disp_data()

End Sub

METHOD DEFENITION FOR DISPLAYING THE DATA IN GRIDVIEW WHEN CLICK AND FORM LOAD.

private void disp_data()

    con.Open()

    cmd.CommandText="select * from Tbl_FinProj "

    cmd.ExecuteNonQuery()

    Dim dt As New Datatable

    Dim da As New SqlDataAdapter(cmd)

    da.Fill(dt)

    dataGridView1.DataSource=dt

    con.Close()

End Sub