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