private void Form1_Load(object sender, EventArgs e) { // Populate the "Suppliers" data table with data. adapter.Fill(dataSet.Suppliers); IWorkbook workbook = spreadsheetControl1.Document; // Load the template document into the SpreadsheetControl. workbook.LoadDocument("Suppliers_template.xlsx"); Worksheet sheet = workbook.Worksheets[0]; // Load data from the "Suppliers" data table into the worksheet starting from the cell "B12". sheet.DataBindings.BindToDataSource(dataSet.Suppliers, 11, 1); }
void buttonCancelChanges_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e) { // Close the cell in-place editor if it's currently active. CloseInplaceEditor(); // Load the latest saved data into the "Suppliers" data table. adapter.Fill(dataSet.Suppliers); }
//一个填充Northwind数据库中产品和供应商到DataSet中去的函数 protected void FillDataSet() { ProductsTableAdapter productadapter = new ProductsTableAdapter(); productadapter.Fill(ds.Products); SuppliersTableAdapter supplieradapter = new SuppliersTableAdapter(); supplieradapter.Fill(ds.Suppliers); }
//connection to the database private void get_data() { ds = new DataSet1(); st = new InventoryTableAdapter(); st.Fill(ds.Inventory); ct = new SuppliersTableAdapter(); ct.Fill(ds.Suppliers); et = new EmployeesTableAdapter(); et.Fill(ds.Employees); }
private void BindWorksheetToDataSource() { dataSet = new NWindDataSet(); adapter = new SuppliersTableAdapter(); // Populate the "Suppliers" data table with data. adapter.Fill(dataSet.Suppliers); IWorkbook workbook = spreadsheetControl.Document; // Load the template document into the SpreadsheetControl. workbook.LoadDocument("Documents\\Suppliers_template.xlsx", DocumentFormat.Xlsx); Worksheet sheet = workbook.Worksheets[0]; // Load data from the "Suppliers" data table into the worksheet starting from the cell "B12". sheet.DataBindings.BindToDataSource(dataSet.Suppliers, 11, 1); }
/* * Function get_data() * Fills database tables using DataSet. */ private void get_data() { ds = new DataSet1(); mt = new MenuTableAdapter(); it = new InventoryTableAdapter(); et = new EmployeesTableAdapter(); ot = new OrdersTableAdapter(); olt = new OrderlineTableAdapter(); st = new SuppliersTableAdapter(); pot = new PurchaseOrdersTableAdapter(); polt = new PurchaseOrderlineTableAdapter(); mt.Fill(ds.Menu); it.Fill(ds.Inventory); et.Fill(ds.Employees); ot.Fill(ds.Orders); olt.Fill(ds.Orderline); st.Fill(ds.Suppliers); pot.Fill(ds.PurchaseOrders); polt.Fill(ds.PurchaseOrderline); }