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