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