private void DataGridRefresh()
{
DataClasses1DataContext dc = new DataClasses1DataContext();
reference reference = new reference();
var query = from q in dc.references
select q;
dataGridView1.DataSource = query;// Attaching the all data with Datagridview
}
private void button1_Click(object sender, EventArgs e)
{
DataClasses1DataContext dc = new DataClasses1DataContext();
reference reference = new reference();
int rowindex = dataGridView1.CurrentRow.Index; // here rowindex will get through currentrow property of datagridview.
reference.firstname = Convert.ToString(dataGridView1.Rows[rowindex].Cells[1].Value);
reference.lastname = Convert.ToString(dataGridView1.Rows[rowindex].Cells[2].Value);
reference.ref_number = Convert.ToString(dataGridView1.Rows[rowindex].Cells[3].Value);
reference.customer = Convert.ToInt16(dataGridView1.Rows[rowindex].Cells[4].Value);
dc.references.InsertOnSubmit(reference); //InsertOnSubmit queries will automatic call thats the data context class handle it.
dc.SubmitChanges();
rowindex = 0;
DataGridRefresh();
}
partial void Updatereference(reference instance);
partial void Deletereference(reference instance);
partial void Insertreference(reference instance);
