private void Search_Click(object sender, EventArgs e)
{
personDataContext pdc = new personDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\MD. REZA UL KARIM\documents\visual studio 2012\Projects\GUI\loginform\Contact_Info.mdf;Integrated Security=True;Connect Timeout=30");
var x = from a in pdc.Persons
where a.Id == int.Parse(textBox1.Text)
select a;
textBox2.Text = x.FirstOrDefault().Name;
textBox3.Text = x.First().Phone;
dataGridView1.DataSource = x.ToList();
}
private void button2_Click(object sender, EventArgs e)
{
personDataContext pdc = new personDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\MD. REZA UL KARIM\documents\visual studio 2012\Projects\GUI\loginform\Contact_Info.mdf;Integrated Security=True;Connect Timeout=30");
Person p = pdc.Persons.SingleOrDefault(x => x.Id == int.Parse(textBox1.Text));
pdc.Persons.DeleteOnSubmit(p);
pdc.SubmitChanges();
//var x=from a in pdc.Persons
// where a.Id==
// select a;
//foreach(person p in x)
//{
// pdc.Persons.DeleteOnSubmit(p);
//}
}
private void Insert_Click(object sender, EventArgs e)
{
personDataContext pdc = new personDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\MD. REZA UL KARIM\documents\visual studio 2012\Projects\GUI\loginform\Contact_Info.mdf;Integrated Security=True;Connect Timeout=30");
Person p = new Person();
p.Id = int.Parse(textBox1.Text);
p.Name = textBox2.Text;
p.Phone = textBox3.Text;
//Person p=new Person
//{
// Id = int.Parse(textBox1.Text);
// Name = textBox2.Text;
// Phone = textBox3.Text;
//}
pdc.Persons.InsertOnSubmit(p);
pdc.SubmitChanges();
GridViewUpadte();
}
private void Update_Click(object sender, EventArgs e)
{
personDataContext pdc = new personDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\MD. REZA UL KARIM\documents\visual studio 2012\Projects\GUI\loginform\Contact_Info.mdf;Integrated Security=True;Connect Timeout=30");
Person p = pdc.Persons.SingleOrDefault(x => x.Id == int.Parse(textBox1.Text));//extension method lemda expresion
p.Name = textBox2.Text;
p.Phone = textBox3.Text;
//LINQ
//var x=from a in pdc.persons
// where a.ID==(textbox1.text)
//Select a;
//x.First().Name = textBox2.Text;
//x.First().Name = textBox2.Text;
pdc.SubmitChanges();
GridViewUpadte();
}
void GridViewUpadte()
{
personDataContext pdc = new personDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\MD. REZA UL KARIM\documents\visual studio 2012\Projects\GUI\loginform\Contact_Info.mdf;Integrated Security=True;Connect Timeout=30");
dataGridView1.DataSource = pdc.Persons;
}