.jpg)
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
a. id int ,primary key
b. fname nvarchar(50)
c. lname 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
//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.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;
}
}
}
}
}
