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(); dsRSandCR ds = new dsRSandCR(); 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 = "dtRSandCRDataTable"; type.Attributes.Add(attribute2); type.Particle = sequence; return(type); }
public override System.Data.DataSet Clone() { dsRSandCR cln = ((dsRSandCR)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return(cln); }
public static System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(System.Xml.Schema.XmlSchemaSet xs) { dsRSandCR ds = new dsRSandCR(); 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); }
private void Form1_Load(object sender, EventArgs e) { //declare connection string, please substitute DataSource with your Server name string cnString = "Data Source=(local);Initial Catalog=RealWorld; Integrated Security=SSPI;"; //declare Connection, command and other related objects SqlConnection conReport = new SqlConnection(cnString); SqlCommand cmdReport = new SqlCommand(); SqlDataReader drReport; DataSet dsReport = new dsRSandCR(); try { //open connection conReport.Open(); //prepare connection object to get the data through reader and populate into dataset cmdReport.CommandType = CommandType.Text; cmdReport.Connection = conReport; cmdReport.CommandText = "Select * FROM BooksInfo Order By BookTitle"; //read data from command object drReport = cmdReport.ExecuteReader(); //load data directly from reader to dataset dsReport.Tables[0].Load(drReport); //close reader and connection drReport.Close(); conReport.Close(); //provide local report information to viewer reportViewer1.LocalReport.ReportEmbeddedResource = "RSandCR.rptRS.rdlc"; //prepare report data source ReportDataSource rds = new ReportDataSource(); rds.Name = "dsRSandCR_dtRSandCR"; rds.Value = dsReport.Tables[0]; reportViewer1.LocalReport.DataSources.Add(rds); //load report viewer reportViewer1.RefreshReport(); // prepare and load crystal reports viewer rptCR reportCR = new rptCR(); // add typed data set as data source reportCR.SetDataSource(dsReport.Tables[0]); // hide group tree which is visible by default for full view of report crystalReportViewer1.DisplayGroupTree = false; // bind report instance with cyrstal report viewer for user display crystalReportViewer1.ReportSource = reportCR; } catch (Exception ex) { //display generic error message back to user MessageBox.Show(ex.Message); } finally { //check if connection is still open then attempt to close it if (conReport.State == ConnectionState.Open) { conReport.Close(); } } }