private void Form2_Load(object sender, EventArgs e) { //establish a connection using datacontext class dc = new myDatabaseDataContext(); Emps = dc.Employees.ToList();//data in table is transferred into list ShowData(); }
private void Form1_Load(object sender, EventArgs e) { myDatabaseDataContext dc = new myDatabaseDataContext(); //dataGridView1.DataSource = dc.Employees; Table <Employee> tab = dc.Employees; dataGridView1.DataSource = tab; }
private void Form3_Load(object sender, EventArgs e) { dc = new myDatabaseDataContext(); //var tab = from E in dc.Emps select E; //dataGridView1.DataSource = tab; //straighwaya bind to grid view dataGridView1.DataSource = from E in dc.Emps select E; var tab = from E in dc.Emps select new { E.Job }; comboBox1.DataSource = tab.Distinct(); comboBox1.DisplayMember = "Job"; comboBox1.SelectedIndex = -1;//no selection flag = true; }