public static System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(System.Xml.Schema.XmlSchemaSet xs)
{
System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType();
System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence();
dsAccess ds = new dsAccess();
xs.Add(ds.GetSchemaSerializable());
System.Xml.Schema.XmlSchemaAny any1 = new System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
System.Xml.Schema.XmlSchemaAny any2 = new System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
System.Xml.Schema.XmlSchemaAttribute attribute1 = new System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
System.Xml.Schema.XmlSchemaAttribute attribute2 = new System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "dtAccessDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
return(type);
}
private void Form1_Load(object sender, EventArgs e)
{
// connection string
string cnString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Apress\chapter10\nwind.mdb;User Id=admin;Password=;";
// string builder for query text
StringBuilder sb = new StringBuilder();
sb.Append("SELECT Products.ProductName, Categories.CategoryName, Products.QuantityPerUnit, Products.UnitsInStock ");
sb.Append("FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID ");
sb.Append("ORDER BY Products.ProductName");
OleDbConnection conReport = new OleDbConnection(cnString);
OleDbCommand cmdReport = new OleDbCommand();
OleDbDataReader drReport;
DataSet dsReport = new dsAccess();
try
{
// open connection
conReport.Open();
cmdReport.CommandType = CommandType.Text;
cmdReport.Connection = conReport;
// get query string from string builder
cmdReport.CommandText = sb.ToString();
// execute query and load result to dataset
drReport = cmdReport.ExecuteReader();
dsReport.Tables[0].Load(drReport);
// close connection
drReport.Close();
conReport.Close();
// prepare report for view
reportViewer1.LocalReport.ReportEmbeddedResource = "AccessReport.rptAccess.rdlc";
ReportDataSource rds = new ReportDataSource();
rds.Name = "dsAccess_dtAccess";
rds.Value = dsReport.Tables[0];
reportViewer1.LocalReport.DataSources.Add(rds);
// preivew the report
reportViewer1.RefreshReport();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (conReport.State == ConnectionState.Open)
{
conReport.Close();
}
}
}
public override System.Data.DataSet Clone()
{
dsAccess cln = ((dsAccess)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return(cln);
}
public static System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(System.Xml.Schema.XmlSchemaSet xs)
{
dsAccess ds = new dsAccess();
System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType();
System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence();
xs.Add(ds.GetSchemaSerializable());
System.Xml.Schema.XmlSchemaAny any = new System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
return(type);
}