MyTypedDs ds = new MyTypedDs(); //hence from below function the DataSet ds has all the values
private void Form2_Load(object sender, EventArgs e) //here the TableAdapter is filling a DataSet
{
DepartmentsTableAdapter daDeps = new DepartmentsTableAdapter();
daDeps.Fill(ds.Departments);
EmployeesTableAdapter daEmps = new EmployeesTableAdapter();
daEmps.Fill(ds.Employees);
}
private void Form2_Load(object sender, EventArgs e)
{
DepartmentsTableAdapter daDeps = new DepartmentsTableAdapter();
daDeps.Fill(ds.Departments);
EmployeesTableAdapter daEmps = new EmployeesTableAdapter();
daEmps.Fill(ds.Employees);
}
private void Button_Click(object sender, RoutedEventArgs e)
{
ds = new MyDataSet();
DepartmentsTableAdapter daDeps = new DepartmentsTableAdapter();
daDeps.Fill(ds.Departments);
EmployeesTableAdapter daEmps = new EmployeesTableAdapter();
daEmps.Fill(ds.Employees);
dgEmps.ItemsSource = ds.Employees.DefaultView;
}
private void Button_Click(object sender, RoutedEventArgs e)
{
ds = new DataSet1();
DepartmentsTableAdapter dadeps = new DepartmentsTableAdapter();
dadeps.Fill(ds.Departments);
EmployeesTableAdapter daemps = new EmployeesTableAdapter();
daemps.Fill(ds.Employees);
mygrid.ItemsSource = ds.Employees;
}
MyDataSet ds; //here firstly 'MyDataSet' is the name of the Typed DataSet which we made----secondly the order should remain the same i.e we can't add Employee first as its a child table---here we don't need to create Connection and a DataAdapter because it is already initialized in the table eg for Departments table in file DataSet we have DepartmentsTableAdapter
private void Button_Click(object sender, RoutedEventArgs e)
{
ds = new MyDataSet();
DepartmentsTableAdapter daDeps = new DepartmentsTableAdapter(); //here we don't need to create Connection and a DataAdapter because it is already initialized in the table--just using it here
daDeps.Fill(ds.Departments); //previously we were mentioning the .Tables in here which was generated during run time...but since we have that, therefore mentioning the table name directly
EmployeesTableAdapter daEmps = new EmployeesTableAdapter(); //similarly for Employee
daEmps.Fill(ds.Employees); //for Fill button
dgEmps.ItemsSource = ds.Employees.DefaultView; //creating a default view for Employees table
}
private void btnFill_Click(object sender, RoutedEventArgs e)
{
ds = new MyDataSet();// creating object of our own already created data set
DepartmentsTableAdapter daDepts = new DepartmentsTableAdapter();
daDepts.Fill(ds.Departments);
EmployeesTableAdapter daEmps = new EmployeesTableAdapter();
daEmps.Fill(ds.Employees);
dgEmps.ItemsSource = ds.Employees.DefaultView;
}
public RegistrationAppForm()
{
InitializeComponent();
// create the dataset and adapters
studentRegistrationDataSet = new StudentRegistrationDataSet();
studentsTableAdapter = new StudentsTableAdapter();
registrationTableAdapter = new RegistrationTableAdapter();
coursesTableAdapter = new CoursesTableAdapter();
departmentsTableAdapter = new DepartmentsTableAdapter();
// register event handlers
buttonUpdate.Click += ButtonUpdate_Click;
this.Load += RegistrationAppForm_Load;
}
