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);