public void CopyRegions(IOdb odb, NorthwindDataSet dataSet)
{
//Processing Regions
LogMessage("Reading Regions...", false);
var adapter1 = new RegionTableAdapter();
var table1 = adapter1.GetData();
LogMessage("processing " + table1.Count.ToString() + " rows", true);
foreach (var row in table1)
{
LogMessage("Regions: " + row.RegionID.ToString() + " ...", false);
var r = new Region {RegionID = row.RegionID, RegionDescription = row.RegionDescription};
odb.Store(r);
LogMessage("saved", true);
}
odb.Commit();
LogMessage("Commit done, starting create index ...", false);
odb.IndexManagerFor<Region>().AddUniqueIndexOn("Region_RegionID_PK_index", Domain.Region.PK);
odb.Commit();
LogMessage(" index created.", true);
long objectCount = NDbUtil.GetAllInstances<Region>(odb).Count;
if (table1.Count == objectCount)
LogMessage(table1.Count + " objects saved", true);
else
LogMessage("Error: " + table1.Count + " rows retrieved but " + objectCount + " objects were saved", true);
LogMessage("Done with Regions" + Environment.NewLine, true);
}
private void GenerateNorthwindNDb()
{
const string ndbFile = "northwind.ndb";
OdbFactory.Delete(ndbFile);
var dataSet = new NorthwindDataSet();
var odb = OdbFactory.Open(ndbFile);
var progress = 0.0;
try
{
LogMessage("Start processing...", true);
CopyCustomers(odb);
StepFinished(progress += 2.75);
CopyCategories(odb);
StepFinished(progress += 0.24);
CopySuppliers(odb);
StepFinished(progress += 0.88);
CopyShippers(odb);
StepFinished(progress += 0.09);
CopyRegions(odb, dataSet);
StepFinished(progress += 0.12);
CopyEmployees(odb);
StepFinished(progress += 0.27);
CopyCustomerDemographics(odb);
CopyCustomerCustomerDemo(odb);
CopyTerritories(odb);
StepFinished(progress += 1.6);
CopyEmployeeTerritories(odb);
StepFinished(progress += 1.48);
CopyProducts(odb);
StepFinished(progress += 2.33);
CopyOrders(odb, ref progress);
CopyOrderDetails(odb, ref progress);
LogMessage("Northwind database is ready: " + ndbFile + ".", true);
LogMessage("Work is done, good job :)", true);
}
catch (Exception e)
{
LogMessage(e.ToString(), true);
}
finally
{
Terminate(odb, dataSet);
}
}
private void LoadDataReport()
{
//Create the local report
LocalReport report = new LocalReport();
report.ReportEmbeddedResource = "RDLCDemo.ReportTest.rdlc";
//Create the dataset
_northWindDataSet = new NorthwindDataSet();
_dataAdapter = new NorthwindDataSetTableAdapters.ProductsByCategoriesTableAdapter();
_northWindDataSet.DataSetName = "NorthwindDataSet";
_northWindDataSet.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
_dataAdapter.ClearBeforeFill = true;
//Created datasource and binding source
ReportDataSource dataSource = new ReportDataSource();
System.Windows.Forms.BindingSource source = new System.Windows.Forms.BindingSource();
dataSource.Name = "ProductsDataSources"; //the datasource name in the RDLC report
dataSource.Value = source;
source.DataMember = "ProductsByCategories";
source.DataSource = _northWindDataSet;
report.DataSources.Add(dataSource);
//Fill Data in the dataset
_dataAdapter.Fill(_northWindDataSet.ProductsByCategories);
//Create the printer/export rdlc printer
RDLCPrinter rdlcPrinter = new RDLCPrinter(report);
rdlcPrinter.BeforeRefresh += rdlcPrinter_BeforeRefresh;
//Load in report viewer
ReportViewer.Report = rdlcPrinter;
}
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);
}
}
}
}
public void Terminate(IOdb odb, NorthwindDataSet dataSet)
{
if (dataSet != null)
dataSet.Dispose();
if (odb == null)
return;
odb.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
var ds = new NorthwindDataSet();
ds.ReadXml(Server.MapPath("~/App_data/veri.xml"));
gv.DataSource = ds;
gv.DataMember = "Customers";
gv.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
var ds = new NorthwindDataSet();
using (var ta = new CustomersTableAdapter())
{
ta.Fill(ds.Customers);
ds.WriteXml(Server.MapPath("~/App_data/veri.xml"),
System.Data.XmlWriteMode.WriteSchema);
}
}
public MainWindow()
{
InitializeComponent();
// Create a DataSet for the Customers data.
this.nwDataSet = new NorthwindDataSet();
this.nwDataSet.DataSetName = "nwDataSet";
// Create a BindingSource for the Customers data.
this.nwBindingSource = new System.Windows.Forms.BindingSource();
this.nwBindingSource.DataMember = "Customers";
this.nwBindingSource.DataSource = this.nwDataSet;
}
public MainWindow()
{
InitializeComponent();
// Create a DataSet for the Customers data.
_nwDataSet = new NorthwindDataSet {DataSetName = "nwDataSet"};
// Create a BindingSource for the Customers data.
_nwBindingSource = new BindingSource
{
DataMember = "Customers",
DataSource = _nwDataSet
};
}
protected void Page_Load(object sender, EventArgs e)
{
string connectionString = WebConfigurationManager.ConnectionStrings["NorthWind"].ConnectionString;
SqlConnection con = new SqlConnection(connectionString);
// Data
string sqlProducts = "SELECT * FROM Products";
string sqlCategories = "SELECT * FROM Categories";
NorthwindDataSet ds = new NorthwindDataSet();
// TO Fill the dataset
SqlDataAdapter da = new SqlDataAdapter(sqlCategories, con);
da.Fill(ds.Categories);
da.SelectCommand.CommandText = sqlProducts;
da.Fill(ds.Products);
// to construct HTML string
StringBuilder htmlStr = new StringBuilder("");
foreach (NorthwindDataSet.CategoriesRow row in ds.Categories)
{
htmlStr.Append("<b>");
htmlStr.Append(row.CategoryName);
htmlStr.Append("</b><br /><i>");
htmlStr.Append(row.Description);
htmlStr.Append("</i><br />");
// Get related product info
// it uses the auxiliary methods GetChildRows()
NorthwindDataSet.ProductsRow[] products = row.GetProductsRows();
foreach (NorthwindDataSet.ProductsRow child in products)
{
htmlStr.Append("<li>");
htmlStr.Append(child.ProductName);
htmlStr.Append("</li>");
}
htmlStr.Append("<br /><br />");
}
HtmlContent.Text = htmlStr.ToString();
}
public void Init()
{
if (File.Exists(DB4O_FILE))
File.Delete(DB4O_FILE);
ds = new NorthwindDataSet();
container = Db4oFactory.OpenFile(Configuration(), DB4O_FILE);
CopyCustomers();
CopyCategories();
CopySuppliers();
CopyShippers();
CopyRegions();
CopyEmployees();
CopyCustomerDemographics();
CopyCustomerCustomerDemo();
CopyTerritories();
CopyEmployeeTerritories();
CopyProducts();
CopyOrders();
CopyOrderDetails();
Terminate();
}
NorthwindDataSet.ProductsRow GetCurrentRowInDB(NorthwindDataSet.ProductsRow RowWithError)
{
TempProductsDataTable = new NorthwindDataSet.ProductsDataTable();
this.productsTableAdapter1.Fill(TempProductsDataTable);
NorthwindDataSet.ProductsRow currentRowInDb =
TempProductsDataTable.FindByProductID(RowWithError.ProductID);
return currentRowInDb;
}
// //'--------------------------------------------------------------------------
// //' This method takes a productsRow and RowVersion
// //' and returns a string of column values to display to the user.
// //'--------------------------------------------------------------------------
string GetRowData(NorthwindDataSet.ProductsRow custRow, DataRowVersion RowVersion)
{
string rowData = "";
for (int i = 0; i <= custRow.ItemArray.Length - 1; i++)
{
rowData += custRow[i, RowVersion].ToString() + " ";
}
return rowData;
}
public virtual int Update(NorthwindDataSet dataSet) {
return this.Adapter.Update(dataSet, "CustomerDemographics");
}
string CreateMessage(NorthwindDataSet.ProductsRow cr)
{
return
"Database: " + GetRowData(GetCurrentRowInDB(cr), DataRowVersion.Default) + Environment.NewLine +
"Original: " + GetRowData(cr, DataRowVersion.Original) + Environment.NewLine +
"Proposed: " + GetRowData(cr, DataRowVersion.Current) + Environment.NewLine +
"Do you still want to update the database with the proposed value?";
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
NorthwindDataSet ds = new NorthwindDataSet();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace)) {
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length)) {
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length)
&& (s1.ReadByte() == s2.ReadByte())); ) {
;
}
if ((s1.Position == s1.Length)) {
return type;
}
}
}
}
finally {
if ((s1 != null)) {
s1.Close();
}
if ((s2 != null)) {
s2.Close();
}
}
}
xs.Add(dsSchema);
return type;
}
public virtual int Fill(NorthwindDataSet.Sales_by_YearDataTable dataTable, System.Nullable<System.DateTime> Beginning_Date, System.Nullable<System.DateTime> Ending_Date) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((Beginning_Date.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((System.DateTime)(Beginning_Date.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
}
if ((Ending_Date.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[2].Value = ((System.DateTime)(Ending_Date.Value));
}
else {
this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
}
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
public virtual int Update(NorthwindDataSet.OrdersDataTable dataTable) {
return this.Adapter.Update(dataTable);
}
public virtual int Update(NorthwindDataSet dataSet) {
return this.Adapter.Update(dataSet, "Orders");
}
public virtual int Update(NorthwindDataSet dataSet) {
return this.Adapter.Update(dataSet, "Territories");
}
public virtual int Fill(NorthwindDataSet.OrdersDataTable dataTable) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
public virtual int Fill(NorthwindDataSet.Products_Above_Average_PriceDataTable dataTable) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
public virtual int Fill(NorthwindDataSet.CustOrdersDetailDataTable dataTable, System.Nullable<int> OrderID) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((OrderID.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((int)(OrderID.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
}
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
public virtual int Fill(NorthwindDataSet.CustOrdersOrdersDataTable dataTable, string CustomerID) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((CustomerID == null)) {
this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = ((string)(CustomerID));
}
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
private void DataRowFromBusinessObject(NorthwindDataSet.CustomersRow row, CustomerDataObject dataObject)
{
row.CustomerID = dataObject.ID;
row.ContactName = dataObject.ContactName;
row.CompanyName = dataObject.CompanyName;
}
public virtual int Update(NorthwindDataSet.TerritoriesDataTable dataTable) {
return this.Adapter.Update(dataTable);
}
void CustomersRowModified(object sender, NorthwindDataSet.CustomersRowChangeEvent e)
{
adapter.Update(NorthWindDataProvider.NorthwindDataSet.Customers);
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
NorthwindDataSet ds = new NorthwindDataSet();
global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "EmployeesDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace)) {
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length)) {
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length)
&& (s1.ReadByte() == s2.ReadByte())); ) {
;
}
if ((s1.Position == s1.Length)) {
return type;
}
}
}
}
finally {
if ((s1 != null)) {
s1.Close();
}
if ((s2 != null)) {
s2.Close();
}
}
}
xs.Add(dsSchema);
return type;
}
public virtual int FillBy(NorthwindDataSet.CustomersDataTable dataTable, string customer) {
this.Adapter.SelectCommand = this.CommandCollection[1];
if ((customer == null)) {
throw new System.ArgumentNullException("customer");
}
else {
this.Adapter.SelectCommand.Parameters[0].Value = ((string)(customer));
}
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
public virtual int Fill(NorthwindDataSet.SalesByCategoryDataTable dataTable, string CategoryName, string OrdYear) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((CategoryName == null)) {
this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = ((string)(CategoryName));
}
if ((OrdYear == null)) {
this.Adapter.SelectCommand.Parameters[2].Value = System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[2].Value = ((string)(OrdYear));
}
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
