C# Database using Datagridview

private void Form1_Load(object sender, EventArgs e)

// TODO: This line of code loads data into the 'impiDbDataSet.Impi' table. You can move, or remove it, as needed.

//this.impiTableAdapter.Fill(this.impiDbDataSet.Impi);

try

string conStrings = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\ImpiDb.mdf;Integrated Security=True;Connect Timeout=30";

string sql = "Select * from tblImpi";

con = new SqlConnection(conStrings);

dataAdapter = new SqlDataAdapter(sql, con);

//ImpiDbDataSet impds = new ImpiDbDataSet();

ds = new DataSet();

SqlCommandBuilder cmdb = new SqlCommandBuilder(dataAdapter);

dataAdapter.Fill(ds, "tblImpi");

BindingSource bndS = new BindingSource();

bndS.DataSource = ds.Tables["tblImpi"];

// impdg.DataSource = ds.Tables["tblImpi"].DefaultView;

//impdg.DataSource = impds.Tables["tblImpi"].DefaultView;

tootip = new ToolTip();

this.impdg.AlternatingRowsDefaultCellStyle.BackColor = Color.Wheat;

// NavigateRecords();

catch (SqlException ex)

MessageBox.Show(ex.Message);

private void btnDelete_Click(object sender, EventArgs e)

if (MessageBox.Show("I you sure you want to delete this record?","Delete",MessageBoxButtons.YesNo)==DialogResult.Yes)

dataAdapter.Update(ds,"tblImpi");