private void button2_Click(object sender, EventArgs e) { MydatabaseDataContext sr = new MydatabaseDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\lenovo\Documents\Visual Studio 2012\Projects\car\car\login.mdf;Integrated Security=True"); Sales_Register st = new Sales_Register(); int s = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString()); var query = sr.Sales_Registers.Where(w => w.Serial_Number == s).FirstOrDefault(); sr.Sales_Registers.DeleteOnSubmit(query); sr.SubmitChanges(); dataGridView1.DataSource = sr.Sales_Registers; }
private void button1_Click(object sender, EventArgs e) { MydatabaseDataContext sr = new MydatabaseDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\lenovo\Documents\Visual Studio 2012\Projects\car\car\login.mdf;Integrated Security=True"); Sales_Register st = new Sales_Register(); st.Date = Convert.ToDateTime(textBox1.Text); st.Type_of_Vehicle = textBox2.Text; st.Model = textBox3.Text; st.Sales_Unit = int.Parse(textBox4.Text); st.Sales_Amount = textBox5.Text; sr.Sales_Registers.InsertOnSubmit(st); sr.SubmitChanges(); dataGridView1.DataSource = sr.Sales_Registers; }
partial void UpdateSales_Register(Sales_Register instance);
partial void DeleteSales_Register(Sales_Register instance);
partial void InsertSales_Register(Sales_Register instance);