Connectivity with SqlServer with DisConnected Mode

this code for Connectivity with DataBase (Ado.NET with Sql Server ) in Dis Connected Mode.....

1.  Create Database test

     Create database test

2.  Create Table p_customer in test Database

     a.  id  int ,primary key 

     b.  fname nvarchar(50)
      c.  lname nvarchar(50)

     d.  dob nvarchar(50)

   use test

   create table p_customer ( id  int primary key, fname nvarchar(50), lname nvarchar(50), dob      nvarchar(50))

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Data.SqlClient;
//Frist we are using this  name  sapce for SqlDataAdapter, DataSet 

 using System.Data;

namespace DisConnectedMode

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

        SqlDataAdapter da;

        DataSet ds;

    private void Bfill_Click(object sender, EventArgs e)

{

        string ConStr = "Data Source=KUSH-PC;Initial Catalog=test;Integrated      Security=True";

       string cmd = "select * from p_customer";

            da = new SqlDataAdapter(cmd, ConStr);

  or  

         da = new SqlDataAdapter("select * from p_customer", "Data Source=KUSH-PC;Initial       Catalog=test;Integrated Security=True");

            ds = new DataSet();

            da.Fill(ds);

            MessageBox.Show("Dataset is filled");

        }

       we are using this  button  for showing data  in gridview

         private void BShow_Click(object sender, EventArgs e)

         {

            dataGridView1.DataSource = ds.Tables[0];

            dataGridView1.Visible = true;

          }

     we are using this  button  for updating data  in database without this button data  is  save  is    tempory database which is  callad DataAdapter................

        private void Bupdatedb_Click(object sender, EventArgs e)

        {

            SqlCommandBuilder cbd = new SqlCommandBuilder(da);

            da.Update(ds);

            MessageBox.Show("Database is  updated");

        }

       we are using this  button  for saving data  

        private void BAdd_Click(object sender, EventArgs e)

        {

            DataTable dt = ds.Tables[0];

            DataRow dr = dt.NewRow();

            dr[0] = txtsrno.Text;

            dr[1] = txtfname.Text;

            dr[2] = txtlname.Text;

            dr[3] = txtdob.Text;

            dt.Rows.Add(dr);

            MessageBox.Show("New row Added");

        }

      we are using this  button  for searching  data with srno

        private void BSearch_Click(object sender, EventArgs e)

        {

            foreach (DataRow dr in ds.Tables[0].Rows)

            {

                if(dr.RowState.ToString ()!="Deleted")

                if (dr[0].ToString() == txtsrno.Text)

                {

                    txtfname.Text = dr[1].ToString();

                    txtlname.Text = dr[2].ToString();

                    txtdob.Text = dr[3].ToString();

                    break;

                }

            }

        }

      we are using this  button  for first record in datatable 

        private void BFirst_Click(object sender, EventArgs e)

        {

            foreach (DataRow dr in ds.Tables[0].Rows)

            {

                txtsrno.Text = dr[0].ToString();

                txtfname.Text = dr[1].ToString();

                txtlname.Text = dr[2].ToString();

                txtdob.Text = dr[3].ToString();

                break;

            }

        }

       we are using this  button  for last record in datatable 

        private void BLast_Click(object sender, EventArgs e)

        {

            foreach (DataRow dr in ds.Tables[0].Rows)

            {

                txtsrno.Text = dr[0].ToString();

                txtfname.Text = dr[1].ToString();

                txtlname.Text = dr[2].ToString();

                txtdob.Text = dr[3].ToString();

            }

        }

        we are using this  button  for next record in datatable 

        private void bNext_Click(object sender, EventArgs e)

        {

            bool ck = false;

            foreach (DataRow dr in ds.Tables[0].Rows)

            {

                if (ck == true)

                {

                    txtsrno.Text = dr[0].ToString();

                    txtfname.Text = dr[1].ToString();

                    txtlname.Text = dr[2].ToString();

                    txtdob.Text = dr[3].ToString();

                    break;

                }

                if (dr[0].ToString() == txtsrno.Text)

                {

                    ck = true;

                }

                 }

        }

       we are using this  button  for previous record in datatable 

        private void Bpre_Click(object sender, EventArgs e)

        {

            int ck = Convert.ToInt32(txtsrno.Text);

            foreach (DataRow dr in ds.Tables[0].Rows)

            {

                if (dr[0].ToString() == ck.ToString())

                {

                    break;

                }

                txtsrno.Text = dr[0].ToString();

                txtfname.Text = dr[1].ToString();

                txtlname.Text = dr[2].ToString();

                txtdob.Text = dr[3].ToString();

            }

        }

        we are using this  button  for delete record in data table 

        private void bDelete_Click(object sender, EventArgs e)

        {

            foreach (DataRow dr in ds.Tables[0].Rows)

            {

                 if(dr.RowState.ToString ()!="Deleted")

                if (txtsrno.Text == dr[0].ToString())

                {

                    dr.Delete();

                    MessageBox.Show("data deleted");

                    break;

                }

            }

        }

         we are using this  button  for modifie  record in datatable 

        private void bModifiy_Click(object sender, EventArgs e)

        {

            foreach (DataRow dr in ds.Tables[0].Rows)

            {

                if (txtsrno.Text == dr[0].ToString())

                {

                    dr[1] = txtfname.Text;

                    dr[2] = txtlname.Text;

                    dr[3] = txtdob.Text;

                    MessageBox.Show("data modified");

                    break;

                }

            }

        }

  


       }

       }