/// <summary> /// Returns a VariablesDataSet, as defined by VariablesDataSet.xsd /// /// In SDSC code, this variable is loaded once, and is stored in an /// Application, or AppServer variable, and queries are run against the stored dataset. /// Other methods in this class are used to query the dataset. /// </summary> /// <param name="networkID"></param> /// <returns></returns> public static VariablesDataset GetVariableDataSet(int networkID) { VariablesDataset ds = new VariablesDataset(); UnitsTableAdapter unitTableAdapter = new UnitsTableAdapter(); VariablesTableAdapter varsTableAdapter = new VariablesTableAdapter(); CategoriesTableAdapter categoriesTableAdapter = new CategoriesTableAdapter(); unitTableAdapter.Connection.ConnectionString = Config.ODDB(); varsTableAdapter.Connection.ConnectionString = Config.ODDB(); categoriesTableAdapter.Connection.ConnectionString = Config.ODDB(); try { unitTableAdapter.Fill(ds.Units); varsTableAdapter.Fill(ds.Variables); categoriesTableAdapter.Fill(ds.Categories); } catch (Exception e) { log.Fatal("Cannot retrieve units or variables from database" + e.Message); //+ unitTableAdapter.Connection.DataSource throw new WaterOneFlowServerException("Cannot retrieve units or variables from database", e); } return(ds); }
public override List <Identity> GetAll(NorthwindConfig config, string whereExpression, OleDbParameter[] oleDbParameters) { #region Declarations List <Identity> result = new List <Identity>(); int recordCount = 0; Category dataset = new Category(); #endregion // get the first 11 rows of the changelog using (OleDbConnection connection = new OleDbConnection(config.ConnectionString)) { CategoriesTableAdapter tableAdapter; tableAdapter = new CategoriesTableAdapter(); tableAdapter.Connection = connection; if (string.IsNullOrEmpty(whereExpression)) { recordCount = tableAdapter.Fill(dataset.Categories); } else { recordCount = tableAdapter.FillByWhereClause(dataset.Categories, whereExpression, oleDbParameters); } } foreach (Category.CategoriesRow row in dataset.Categories.Rows) { // use where expression !! result.Add(new Identity(this.EntityName, row.CategoryID.ToString())); } return(result); }
static void Main(string[] args) { using (NorthwindDataSet ds = new NorthwindDataSet()) using (CategoriesTableAdapter tac = new CategoriesTableAdapter()) using (ProductsTableAdapter tap = new ProductsTableAdapter()) { tac.Fill(ds.Categories); tap.Fill(ds.Products); foreach (var item in ds.Categories) { Console.WriteLine("{0} {1} {2}", item.ItemArray); NorthwindDataSet.ProductsRow[] childs = item.GetProductsRows(); foreach (var item2 in childs) { Console.WriteLine("\t{0} {1} {2} {3} ", item2.CategoryID, item2.ProductID, item2.ProductName, item2.UnitPrice); } } } }
// Populate your datasources for an editing session using the following method. protected override void FillDataSources(XtraReport report, string reportName, bool isDesignActive) { DataSet1 dataSet = (DataSet1)report.GetDataSourceByName("XtraReport1Data"); using (var categoriesTableAdapter = new CategoriesTableAdapter()) using (var productsTableAdapter = new ProductsTableAdapter()) { categoriesTableAdapter.Fill(dataSet.Categories); productsTableAdapter.Fill(dataSet.Products); } }
public static Northwind CreateNorthwindData() { var northwind = new Northwind(); using (var categoriesAdapter = new CategoriesTableAdapter()) using (var productsAdapter = new ProductsTableAdapter()) { categoriesAdapter.Fill(northwind.Categories); productsAdapter.Fill(northwind.Products); } return(northwind); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DrillDownDataSet ddds = new DrillDownDataSet(); CategoriesTableAdapter cta = new CategoriesTableAdapter(); cta.Fill(ddds.Categories); Session["DrillDownDataSet"] = ddds; Session["detailsLevel"] = 0; ShowCategories(); } }
protected nwndDataSet GetData() { if ((nwndDataSet)Session["dataset"] == null) { nwndDataSet ds = new nwndDataSet(); CategoriesTableAdapter cta = new CategoriesTableAdapter(); ProductsTableAdapter pta = new ProductsTableAdapter(); cta.Fill(ds.Categories); pta.Fill(ds.Products); Session["dataset"] = ds; } return((nwndDataSet)Session["dataset"]); }
protected void Application_Start(object sender, EventArgs e) { var dataSet1 = new DataSet1(); using (var categoriesAdapter = new CategoriesTableAdapter()) { categoriesAdapter.Fill(dataSet1.Categories); var categoriesProvider = new ObjectDataProvider(dataSet1); DataProviderRepository.Current.Register("Categories", "Categories", categoriesProvider); } var dataSet2 = new DataSet2(); using (var customersAdapter = new CustomersTableAdapter()) { customersAdapter.Fill(dataSet2.Customers); var customersProvider = new ObjectDataProvider(dataSet2); DataProviderRepository.Current.Register("Customers", "Customers", customersProvider); } }
static object CreateDataSource() { var dataSource = new nwindDataSet(); var connection = new OleDbConnection(); connection.ConnectionString = Properties.Settings.Default.nwindConnectionString; CategoriesTableAdapter categories = new CategoriesTableAdapter(); categories.Connection = connection; categories.Fill(dataSource.Categories); ProductsTableAdapter products = new ProductsTableAdapter(); products.Connection = connection; products.Fill(dataSource.Products); return(dataSource); }
private static void Main() { var dataSet = new NorthwindDataSet(); var tblAdapter = new ProductsTableAdapter(); tblAdapter.Fill(dataSet.Products); var tblAdapterCategories = new CategoriesTableAdapter(); tblAdapterCategories.Fill(dataSet.Categories); foreach (var row in dataSet.Products) { Console.WriteLine($"{row.ProductName}"); } var peterProduct = dataSet.Products.FirstOrDefault(x => x.ProductName == "Peter"); var gabrielProduct = dataSet.Products.FirstOrDefault(x => x.ProductName == "Gabriel"); if (gabrielProduct == default(NorthwindDataSet.ProductsRow) && peterProduct == default(NorthwindDataSet.ProductsRow)) { var newRow = dataSet.Products.NewProductsRow(); newRow.ProductName = "Gabriel"; newRow.Discontinued = false; newRow.CategoriesRow = dataSet.Categories.First(); dataSet.Products.AddProductsRow(newRow); } else if (peterProduct == default(NorthwindDataSet.ProductsRow)) { gabrielProduct.BeginEdit(); gabrielProduct.ProductName = "Peter"; gabrielProduct.EndEdit(); } else if (gabrielProduct == default(NorthwindDataSet.ProductsRow)) { peterProduct.Delete(); } tblAdapter.Update(dataSet); Console.ReadLine(); }
public DataControlCls() { CategoriesAdapter.Fill(nwdataset.Categories); }
public ClsCategories() { adapter2.Fill(northwindDataSet1.Categories); }
/// <summary> /// Returns a VariablesDataSet, as defined by VariablesDataSet.xsd /// /// In SDSC code, this variable is loaded once, and is stored in an /// Application, or AppServer variable, and queries are run against the stored dataset. /// Other methods in this class are used to query the dataset. /// </summary> /// <param name="networkID"></param> /// <returns></returns> public static VariablesDataset GetVariableDataSet(int networkID) { VariablesDataset ds = new VariablesDataset(); UnitsTableAdapter unitTableAdapter = new UnitsTableAdapter(); VariablesTableAdapter varsTableAdapter = new VariablesTableAdapter(); CategoriesTableAdapter categoriesTableAdapter = new CategoriesTableAdapter(); unitTableAdapter.Connection.ConnectionString = Config.ODDB(); varsTableAdapter.Connection.ConnectionString = Config.ODDB(); categoriesTableAdapter.Connection.ConnectionString = Config.ODDB(); try { unitTableAdapter.Fill(ds.Units); varsTableAdapter.Fill(ds.Variables); categoriesTableAdapter.Fill(ds.Categories); } catch (Exception e) { log.Fatal("Cannot retrieve units or variables from database" + e.Message); //+ unitTableAdapter.Connection.DataSource throw new WaterOneFlowServerException("Cannot retrieve units or variables from database", e); } return ds; }
public void ProcessRequest(HttpContext context) { _context = context; _req = context.Request; _res = context.Response; if (!string.IsNullOrEmpty(_req.QueryString["t"])) { switch (_req.QueryString["t"].ToLower()) { case "categories": if (!string.IsNullOrEmpty(_req.QueryString["id"])) { cata = new CategoriesTableAdapter(); var ds = new NorthwindDataSet(); cata.FillByCategoryID(ds.Categories, int.Parse(_req.QueryString["id"])); foreach (var item in ds.Categories) { item.Picture = null; } _res.ContentType = "text/xml"; _res.ContentEncoding = Encoding.UTF8; _res.Write("<?xml version=\"1.0\" encoding=\"utf-8\" ?>"); ds.WriteXml(_res.OutputStream); } else { cata = new CategoriesTableAdapter(); var ds = new NorthwindDataSet(); cata.Fill(ds.Categories); foreach (var item in ds.Categories) { item.Picture = null; } _res.ContentType = "text/xml"; _res.ContentEncoding = Encoding.UTF8; _res.Write("<?xml version=\"1.0\" encoding=\"utf-8\" ?>"); ds.WriteXml(_res.OutputStream); } return; case "products": if (!string.IsNullOrEmpty(_req.QueryString["id"])) { prta = new ProductsTableAdapter(); var ds = new NorthwindDataSet(); prta.FillByProductID(ds.Products, int.Parse(_req.QueryString["id"])); _res.ContentType = "text/xml"; _res.ContentEncoding = Encoding.UTF8; _res.Write("<?xml version=\"1.0\" encoding=\"utf-8\" ?>"); ds.WriteXml(_res.OutputStream); } else if (!string.IsNullOrEmpty(_req.QueryString["cid"])) { prta = new ProductsTableAdapter(); var ds = new NorthwindDataSet(); prta.FillByCategoryID(ds.Products, int.Parse(_req.QueryString["cid"])); _res.ContentType = "text/xml"; _res.ContentEncoding = Encoding.UTF8; _res.Write("<?xml version=\"1.0\" encoding=\"utf-8\" ?>"); ds.WriteXml(_res.OutputStream); } else { prta = new ProductsTableAdapter(); var ds = new NorthwindDataSet(); prta.Fill(ds.Products); _res.ContentType = "text/xml"; _res.ContentEncoding = Encoding.UTF8; _res.Write("<?xml version=\"1.0\" encoding=\"utf-8\" ?>"); ds.WriteXml(_res.OutputStream); } return; default: break; } } }
public ClsNorthWind() { adapter.Fill(nwd.Products); categories.Fill(nwd.Categories); }