private void Refresh() { StudentDataClasses1DataContext SDCD1 = new StudentDataClasses1DataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=c:\users\ehtesham mehmood\documents\visual studio 2012\Projects\FP1\FP1\abc.mdf;Integrated Security=True;Connect Timeout=30"); StudentInfo SI = new StudentInfo(); var query = from q in SDCD1.StudentInfos select q; dataGridView1.DataSource = query;// Attaching the all data with Datagridview }
private void Form1_Load(object sender, EventArgs e) { StudentDataClasses1DataContext SDCD1 = new StudentDataClasses1DataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=c:\users\ehtesham mehmood\documents\visual studio 2012\Projects\FP1\FP1\abc.mdf;Integrated Security=True;Connect Timeout=30"); StudentInfo SI = new StudentInfo(); //dataGridView1.ColumnCount = 4; //dataGridView1.Columns[0].Name = "Student ID"; //dataGridView1.Columns[1].Name = "Student Name"; //dataGridView1.Columns[2].Name = "Student Marks"; //dataGridView1.Columns[3].Name = "Student Grade"; var query = from q in SDCD1.StudentInfos select q; dataGridView1.DataSource = query; }
private void SaveButton_Click(object sender, EventArgs e) { StudentDataClasses1DataContext SDCD1 = new StudentDataClasses1DataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=c:\users\ehtesham mehmood\documents\visual studio 2012\Projects\FP1\FP1\abc.mdf;Integrated Security=True;Connect Timeout=30"); StudentInfo SI = new StudentInfo(); int rowindex = dataGridView1.CurrentRow.Index; // here rowindex will get through currentrow property of datagridview. SI.Id = Convert.ToInt32(dataGridView1.Rows[rowindex].Cells[0].Value); SI.Name = Convert.ToString(dataGridView1.Rows[rowindex].Cells[1].Value); SI.Marks = Convert.ToInt32(dataGridView1.Rows[rowindex].Cells[2].Value); SI.Grade = Convert.ToString(dataGridView1.Rows[rowindex].Cells[3].Value); SDCD1.StudentInfos.InsertOnSubmit(SI);//InsertOnSubmit queries will automatic call thats the data context class handle it. SDCD1.SubmitChanges(); MessageBox.Show("Saved"); rowindex = 0; }
private void button1_Click(object sender, EventArgs e) { int iid = 0; StudentDataClasses1DataContext SDCD1 = new StudentDataClasses1DataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=c:\users\ehtesham mehmood\documents\visual studio 2012\Projects\FP1\FP1\abc.mdf;Integrated Security=True;Connect Timeout=30"); StudentInfo SI = new StudentInfo(); int rowindex = dataGridView1.CurrentRow.Index; // here rowindex will get through currentrow property of datagridview. iid = Convert.ToInt32(dataGridView1.Rows[rowindex].Cells[0].Value); var delete = from p in SDCD1.StudentInfos where p.Id == iid// match the ecords. select p; SDCD1.StudentInfos.DeleteAllOnSubmit(delete);// DeleteAllOnSubmit function will call and queries will automatic call thats the data context class handle it. SDCD1.SubmitChanges(); // SI = SDCD1.StudentInfos.Single(c => c.Id == iid); rowindex = 0; MessageBox.Show("deleted"); Refresh(); }
private void button2_Click(object sender, EventArgs e) { int iid = 0; StudentDataClasses1DataContext SDCD1 = new StudentDataClasses1DataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=c:\users\ehtesham mehmood\documents\visual studio 2012\Projects\FP1\FP1\abc.mdf;Integrated Security=True;Connect Timeout=30"); StudentInfo SI = new StudentInfo(); int rowindex = dataGridView1.CurrentRow.Index; // here rowindex will get through currentrow property of datagridview. iid = Convert.ToInt32(dataGridView1.Rows[rowindex].Cells[0].Value); var update = from s1 in SDCD1.StudentInfos where s1.Id == iid select s1; foreach (var v in update) { v.Id = Convert.ToInt32(dataGridView1.Rows[rowindex].Cells[0].Value); v.Name = Convert.ToString(dataGridView1.Rows[rowindex].Cells[1].Value); v.Marks = Convert.ToInt32(dataGridView1.Rows[rowindex].Cells[2].Value); v.Grade = Convert.ToString(dataGridView1.Rows[rowindex].Cells[3].Value); SDCD1.SubmitChanges(); // here will submitchanges function call and queries will automatic call. } MessageBox.Show("Updated"); Refresh();// refresh the data gridview. }