private void Button_Click(object sender, RoutedEventArgs e) { ds = new MyDataSet(); DepartmentTableAdapter daDeps = new DepartmentTableAdapter(); daDeps.Fill(ds.Department); EmployeeInfoTableAdapter daEmp = new EmployeeInfoTableAdapter(); daEmp.Fill(ds.EmployeeInfo); dgEmps.ItemsSource = ds.EmployeeInfo.DefaultView; }
private void Window_Loaded(object sender, RoutedEventArgs e) { //cn.ConnectionString = ConfigurationManager.ConnectionStrings["cn"].ConnectionString; cn.Open(); SqlCommand cmdSelect = new SqlCommand(); cmdSelect.Connection = cn; cmdSelect.CommandType = CommandType.Text; cmdSelect.CommandText = "select * from EmployeeInfo"; da.SelectCommand = cmdSelect; da.Fill(ds, "Emps"); cmdSelect.CommandType = CommandType.Text; cmdSelect.CommandText = "Select* from Department"; da.Fill(ds, "Deps"); DepartmentTableAdapter daDeps = new DepartmentTableAdapter(); daDeps.Fill(mds.Department); EmployeeInfoTableAdapter daEmps = new EmployeeInfoTableAdapter(); daEmps.Fill(mds.EmployeeInfo); }
private void Button_Click_1(object sender, RoutedEventArgs e) { EmployeeInfoTableAdapter daEmp = new EmployeeInfoTableAdapter(); daEmp.Update(ds.EmployeeInfo); }