Link Search Menu Expand Document

Create Report from SQL Server C# 2005 - Crystal Reports

BarCode SDK sample in Crystal Reports demonstrating ‘Create Report from SQL Server C# 2005’

CrystalReport1.cs
//------------------------------------------------------------------------------
// <auto-generated>
//     This code was generated by a tool.
//     Runtime Version:2.0.50727.4927
//
//     Changes to this file may cause incorrect behavior and will be lost if
//     the code is regenerated.
// </auto-generated>
//------------------------------------------------------------------------------

namespace ReportFromSqlServer {
    using System;
    using System.ComponentModel;
    using CrystalDecisions.Shared;
    using CrystalDecisions.ReportSource;
    using CrystalDecisions.CrystalReports.Engine;
    
    
    public class CrystalReport1 : ReportClass {
        
        public CrystalReport1() {
        }
        
        public override string ResourceName {
            get {
                return "CrystalReport1.rpt";
            }
            set {
                // Do nothing
            }
        }
        
        [Browsable(false)]
        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
        public CrystalDecisions.CrystalReports.Engine.Section Section1 {
            get {
                return this.ReportDefinition.Sections[0];
            }
        }
        
        [Browsable(false)]
        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
        public CrystalDecisions.CrystalReports.Engine.Section Section2 {
            get {
                return this.ReportDefinition.Sections[1];
            }
        }
        
        [Browsable(false)]
        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
        public CrystalDecisions.CrystalReports.Engine.Section Section3 {
            get {
                return this.ReportDefinition.Sections[2];
            }
        }
        
        [Browsable(false)]
        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
        public CrystalDecisions.CrystalReports.Engine.Section Section4 {
            get {
                return this.ReportDefinition.Sections[3];
            }
        }
        
        [Browsable(false)]
        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
        public CrystalDecisions.CrystalReports.Engine.Section Section5 {
            get {
                return this.ReportDefinition.Sections[4];
            }
        }
    }
    
    [System.Drawing.ToolboxBitmapAttribute(typeof(CrystalDecisions.Shared.ExportOptions), "report.bmp")]
    public class CachedCrystalReport1 : Component, ICachedReport {
        
        public CachedCrystalReport1() {
        }
        
        [Browsable(false)]
        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
        public virtual bool IsCacheable {
            get {
                return true;
            }
            set {
                // 
            }
        }
        
        [Browsable(false)]
        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
        public virtual bool ShareDBLogonInfo {
            get {
                return false;
            }
            set {
                // 
            }
        }
        
        [Browsable(false)]
        [DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
        public virtual System.TimeSpan CacheTimeOut {
            get {
                return CachedReportConstants.DEFAULT_TIMEOUT;
            }
            set {
                // 
            }
        }
        
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
            CrystalReport1 rpt = new CrystalReport1();
            rpt.Site = this.Site;
            return rpt;
        }
        
        public virtual string GetCustomizedCacheKey(RequestContext request) {
            String key = null;
            // // The following is the code used to generate the default
            // // cache key for caching report jobs in the ASP.NET Cache.
            // // Feel free to modify this code to suit your needs.
            // // Returning key == null causes the default cache key to
            // // be generated.
            // 
            // key = RequestContext.BuildCompleteCacheKey(
            //     request,
            //     null,       // sReportFilename
            //     this.GetType(),
            //     this.ShareDBLogonInfo );
            return key;
        }
    }
}

DataSet1.Designer.cs
��//------------------------------------------------------------------------------

// <auto-generated>

//     This code was generated by a tool.

//     Runtime Version:2.0.50727.4927

//

//     Changes to this file may cause incorrect behavior and will be lost if

//     the code is regenerated.

// </auto-generated>

//------------------------------------------------------------------------------



#pragma warning disable 1591



namespace ReportFromSqlServer {

    

    

    /// <summary>

    ///Represents a strongly typed in-memory cache of data.

    ///</summary>

    [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]

    [global::System.Serializable()]

    [global::System.ComponentModel.DesignerCategoryAttribute("code")]

    [global::System.ComponentModel.ToolboxItem(true)]

    [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedDataSetSchema")]

    [global::System.Xml.Serialization.XmlRootAttribute("DataSet1")]

    [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.DataSet")]

    public partial class DataSet1 : global::System.Data.DataSet {

        

        private ProductsDataTable tableProducts;

        

        private global::System.Data.SchemaSerializationMode _schemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        public DataSet1() {

            this.BeginInit();

            this.InitClass();

            global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);

            base.Tables.CollectionChanged += schemaChangedHandler;

            base.Relations.CollectionChanged += schemaChangedHandler;

            this.EndInit();

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        protected DataSet1(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) : 

                base(info, context, false) {

            if ((this.IsBinarySerialized(info, context) == true)) {

                this.InitVars(false);

                global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler1 = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);

                this.Tables.CollectionChanged += schemaChangedHandler1;

                this.Relations.CollectionChanged += schemaChangedHandler1;

                return;

            }

            string strSchema = ((string)(info.GetValue("XmlSchema", typeof(string))));

            if ((this.DetermineSchemaSerializationMode(info, context) == global::System.Data.SchemaSerializationMode.IncludeSchema)) {

                global::System.Data.DataSet ds = new global::System.Data.DataSet();

                ds.ReadXmlSchema(new global::System.Xml.XmlTextReader(new global::System.IO.StringReader(strSchema)));

                if ((ds.Tables["Products"] != null)) {

                    base.Tables.Add(new ProductsDataTable(ds.Tables["Products"]));

                }

                this.DataSetName = ds.DataSetName;

                this.Prefix = ds.Prefix;

                this.Namespace = ds.Namespace;

                this.Locale = ds.Locale;

                this.CaseSensitive = ds.CaseSensitive;

                this.EnforceConstraints = ds.EnforceConstraints;

                this.Merge(ds, false, global::System.Data.MissingSchemaAction.Add);

                this.InitVars();

            }

            else {

                this.ReadXmlSchema(new global::System.Xml.XmlTextReader(new global::System.IO.StringReader(strSchema)));

            }

            this.GetSerializationData(info, context);

            global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);

            base.Tables.CollectionChanged += schemaChangedHandler;

            this.Relations.CollectionChanged += schemaChangedHandler;

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.ComponentModel.Browsable(false)]

        [global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)]

        public ProductsDataTable Products {

            get {

                return this.tableProducts;

            }

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.ComponentModel.BrowsableAttribute(true)]

        [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Visible)]

        public override global::System.Data.SchemaSerializationMode SchemaSerializationMode {

            get {

                return this._schemaSerializationMode;

            }

            set {

                this._schemaSerializationMode = value;

            }

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)]

        public new global::System.Data.DataTableCollection Tables {

            get {

                return base.Tables;

            }

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)]

        public new global::System.Data.DataRelationCollection Relations {

            get {

                return base.Relations;

            }

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        protected override void InitializeDerivedDataSet() {

            this.BeginInit();

            this.InitClass();

            this.EndInit();

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        public override global::System.Data.DataSet Clone() {

            DataSet1 cln = ((DataSet1)(base.Clone()));

            cln.InitVars();

            cln.SchemaSerializationMode = this.SchemaSerializationMode;

            return cln;

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        protected override bool ShouldSerializeTables() {

            return false;

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        protected override bool ShouldSerializeRelations() {

            return false;

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        protected override void ReadXmlSerializable(global::System.Xml.XmlReader reader) {

            if ((this.DetermineSchemaSerializationMode(reader) == global::System.Data.SchemaSerializationMode.IncludeSchema)) {

                this.Reset();

                global::System.Data.DataSet ds = new global::System.Data.DataSet();

                ds.ReadXml(reader);

                if ((ds.Tables["Products"] != null)) {

                    base.Tables.Add(new ProductsDataTable(ds.Tables["Products"]));

                }

                this.DataSetName = ds.DataSetName;

                this.Prefix = ds.Prefix;

                this.Namespace = ds.Namespace;

                this.Locale = ds.Locale;

                this.CaseSensitive = ds.CaseSensitive;

                this.EnforceConstraints = ds.EnforceConstraints;

                this.Merge(ds, false, global::System.Data.MissingSchemaAction.Add);

                this.InitVars();

            }

            else {

                this.ReadXml(reader);

                this.InitVars();

            }

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        protected override global::System.Xml.Schema.XmlSchema GetSchemaSerializable() {

            global::System.IO.MemoryStream stream = new global::System.IO.MemoryStream();

            this.WriteXmlSchema(new global::System.Xml.XmlTextWriter(stream, null));

            stream.Position = 0;

            return global::System.Xml.Schema.XmlSchema.Read(new global::System.Xml.XmlTextReader(stream), null);

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        internal void InitVars() {

            this.InitVars(true);

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        internal void InitVars(bool initTable) {

            this.tableProducts = ((ProductsDataTable)(base.Tables["Products"]));

            if ((initTable == true)) {

                if ((this.tableProducts != null)) {

                    this.tableProducts.InitVars();

                }

            }

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        private void InitClass() {

            this.DataSetName = "DataSet1";

            this.Prefix = "";

            this.Namespace = "http://tempuri.org/DataSet1.xsd";

            this.EnforceConstraints = true;

            this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;

            this.tableProducts = new ProductsDataTable();

            base.Tables.Add(this.tableProducts);

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        private bool ShouldSerializeProducts() {

            return false;

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        private void SchemaChanged(object sender, global::System.ComponentModel.CollectionChangeEventArgs e) {

            if ((e.Action == global::System.ComponentModel.CollectionChangeAction.Remove)) {

                this.InitVars();

            }

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {

            DataSet1 ds = new DataSet1();

            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 delegate void ProductsRowChangeEventHandler(object sender, ProductsRowChangeEvent e);

        

        /// <summary>

        ///Represents the strongly named DataTable class.

        ///</summary>

        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]

        [global::System.Serializable()]

        [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]

        public partial class ProductsDataTable : global::System.Data.DataTable, global::System.Collections.IEnumerable {

            

            private global::System.Data.DataColumn columnProduct_ID;

            

            private global::System.Data.DataColumn columnProduct_Name;

            

            private global::System.Data.DataColumn columnProduct_Description;

            

            private global::System.Data.DataColumn columnBarCode;

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public ProductsDataTable() {

                this.TableName = "Products";

                this.BeginInit();

                this.InitClass();

                this.EndInit();

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            internal ProductsDataTable(global::System.Data.DataTable table) {

                this.TableName = table.TableName;

                if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {

                    this.CaseSensitive = table.CaseSensitive;

                }

                if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {

                    this.Locale = table.Locale;

                }

                if ((table.Namespace != table.DataSet.Namespace)) {

                    this.Namespace = table.Namespace;

                }

                this.Prefix = table.Prefix;

                this.MinimumCapacity = table.MinimumCapacity;

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            protected ProductsDataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) : 

                    base(info, context) {

                this.InitVars();

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public global::System.Data.DataColumn Product_IDColumn {

                get {

                    return this.columnProduct_ID;

                }

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public global::System.Data.DataColumn Product_NameColumn {

                get {

                    return this.columnProduct_Name;

                }

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public global::System.Data.DataColumn Product_DescriptionColumn {

                get {

                    return this.columnProduct_Description;

                }

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public global::System.Data.DataColumn BarCodeColumn {

                get {

                    return this.columnBarCode;

                }

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            [global::System.ComponentModel.Browsable(false)]

            public int Count {

                get {

                    return this.Rows.Count;

                }

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public ProductsRow this[int index] {

                get {

                    return ((ProductsRow)(this.Rows[index]));

                }

            }

            

            public event ProductsRowChangeEventHandler ProductsRowChanging;

            

            public event ProductsRowChangeEventHandler ProductsRowChanged;

            

            public event ProductsRowChangeEventHandler ProductsRowDeleting;

            

            public event ProductsRowChangeEventHandler ProductsRowDeleted;

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public void AddProductsRow(ProductsRow row) {

                this.Rows.Add(row);

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public ProductsRow AddProductsRow(int Product_ID, string Product_Name, string Product_Description, byte[] BarCode) {

                ProductsRow rowProductsRow = ((ProductsRow)(this.NewRow()));

                object[] columnValuesArray = new object[] {

                        Product_ID,

                        Product_Name,

                        Product_Description,

                        BarCode};

                rowProductsRow.ItemArray = columnValuesArray;

                this.Rows.Add(rowProductsRow);

                return rowProductsRow;

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public virtual global::System.Collections.IEnumerator GetEnumerator() {

                return this.Rows.GetEnumerator();

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public override global::System.Data.DataTable Clone() {

                ProductsDataTable cln = ((ProductsDataTable)(base.Clone()));

                cln.InitVars();

                return cln;

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            protected override global::System.Data.DataTable CreateInstance() {

                return new ProductsDataTable();

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            internal void InitVars() {

                this.columnProduct_ID = base.Columns["Product ID"];

                this.columnProduct_Name = base.Columns["Product Name"];

                this.columnProduct_Description = base.Columns["Product Description"];

                this.columnBarCode = base.Columns["BarCode"];

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            private void InitClass() {

                this.columnProduct_ID = new global::System.Data.DataColumn("Product ID", typeof(int), null, global::System.Data.MappingType.Element);

                base.Columns.Add(this.columnProduct_ID);

                this.columnProduct_Name = new global::System.Data.DataColumn("Product Name", typeof(string), null, global::System.Data.MappingType.Element);

                base.Columns.Add(this.columnProduct_Name);

                this.columnProduct_Description = new global::System.Data.DataColumn("Product Description", typeof(string), null, global::System.Data.MappingType.Element);

                base.Columns.Add(this.columnProduct_Description);

                this.columnBarCode = new global::System.Data.DataColumn("BarCode", typeof(byte[]), null, global::System.Data.MappingType.Element);

                base.Columns.Add(this.columnBarCode);

                this.columnProduct_Name.MaxLength = 100;

                this.columnProduct_Description.MaxLength = 255;

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public ProductsRow NewProductsRow() {

                return ((ProductsRow)(this.NewRow()));

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {

                return new ProductsRow(builder);

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            protected override global::System.Type GetRowType() {

                return typeof(ProductsRow);

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {

                base.OnRowChanged(e);

                if ((this.ProductsRowChanged != null)) {

                    this.ProductsRowChanged(this, new ProductsRowChangeEvent(((ProductsRow)(e.Row)), e.Action));

                }

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {

                base.OnRowChanging(e);

                if ((this.ProductsRowChanging != null)) {

                    this.ProductsRowChanging(this, new ProductsRowChangeEvent(((ProductsRow)(e.Row)), e.Action));

                }

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {

                base.OnRowDeleted(e);

                if ((this.ProductsRowDeleted != null)) {

                    this.ProductsRowDeleted(this, new ProductsRowChangeEvent(((ProductsRow)(e.Row)), e.Action));

                }

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {

                base.OnRowDeleting(e);

                if ((this.ProductsRowDeleting != null)) {

                    this.ProductsRowDeleting(this, new ProductsRowChangeEvent(((ProductsRow)(e.Row)), e.Action));

                }

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public void RemoveProductsRow(ProductsRow row) {

                this.Rows.Remove(row);

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            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();

                DataSet1 ds = new DataSet1();

                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 = "ProductsDataTable";

                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;

            }

        }

        

        /// <summary>

        ///Represents strongly named DataRow class.

        ///</summary>

        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]

        public partial class ProductsRow : global::System.Data.DataRow {

            

            private ProductsDataTable tableProducts;

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            internal ProductsRow(global::System.Data.DataRowBuilder rb) : 

                    base(rb) {

                this.tableProducts = ((ProductsDataTable)(this.Table));

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public int Product_ID {

                get {

                    try {

                        return ((int)(this[this.tableProducts.Product_IDColumn]));

                    }

                    catch (global::System.InvalidCastException e) {

                        throw new global::System.Data.StrongTypingException("The value for column \'Product ID\' in table \'Products\' is DBNull.", e);

                    }

                }

                set {

                    this[this.tableProducts.Product_IDColumn] = value;

                }

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public string Product_Name {

                get {

                    try {

                        return ((string)(this[this.tableProducts.Product_NameColumn]));

                    }

                    catch (global::System.InvalidCastException e) {

                        throw new global::System.Data.StrongTypingException("The value for column \'Product Name\' in table \'Products\' is DBNull.", e);

                    }

                }

                set {

                    this[this.tableProducts.Product_NameColumn] = value;

                }

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public string Product_Description {

                get {

                    try {

                        return ((string)(this[this.tableProducts.Product_DescriptionColumn]));

                    }

                    catch (global::System.InvalidCastException e) {

                        throw new global::System.Data.StrongTypingException("The value for column \'Product Description\' in table \'Products\' is DBNull.", e);

                    }

                }

                set {

                    this[this.tableProducts.Product_DescriptionColumn] = value;

                }

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public byte[] BarCode {

                get {

                    try {

                        return ((byte[])(this[this.tableProducts.BarCodeColumn]));

                    }

                    catch (global::System.InvalidCastException e) {

                        throw new global::System.Data.StrongTypingException("The value for column \'BarCode\' in table \'Products\' is DBNull.", e);

                    }

                }

                set {

                    this[this.tableProducts.BarCodeColumn] = value;

                }

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public bool IsProduct_IDNull() {

                return this.IsNull(this.tableProducts.Product_IDColumn);

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public void SetProduct_IDNull() {

                this[this.tableProducts.Product_IDColumn] = global::System.Convert.DBNull;

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public bool IsProduct_NameNull() {

                return this.IsNull(this.tableProducts.Product_NameColumn);

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public void SetProduct_NameNull() {

                this[this.tableProducts.Product_NameColumn] = global::System.Convert.DBNull;

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public bool IsProduct_DescriptionNull() {

                return this.IsNull(this.tableProducts.Product_DescriptionColumn);

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public void SetProduct_DescriptionNull() {

                this[this.tableProducts.Product_DescriptionColumn] = global::System.Convert.DBNull;

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public bool IsBarCodeNull() {

                return this.IsNull(this.tableProducts.BarCodeColumn);

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public void SetBarCodeNull() {

                this[this.tableProducts.BarCodeColumn] = global::System.Convert.DBNull;

            }

        }

        

        /// <summary>

        ///Row event argument class

        ///</summary>

        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]

        public class ProductsRowChangeEvent : global::System.EventArgs {

            

            private ProductsRow eventRow;

            

            private global::System.Data.DataRowAction eventAction;

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public ProductsRowChangeEvent(ProductsRow row, global::System.Data.DataRowAction action) {

                this.eventRow = row;

                this.eventAction = action;

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public ProductsRow Row {

                get {

                    return this.eventRow;

                }

            }

            

            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

            public global::System.Data.DataRowAction Action {

                get {

                    return this.eventAction;

                }

            }

        }

    }

}

namespace ReportFromSqlServer.DataSet1TableAdapters {

    

    

    /// <summary>

    ///Represents the connection and commands used to retrieve and save data.

    ///</summary>

    [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]

    [global::System.ComponentModel.DesignerCategoryAttribute("code")]

    [global::System.ComponentModel.ToolboxItem(true)]

    [global::System.ComponentModel.DataObjectAttribute(true)]

    [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" +

        ", Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]

    [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]

    public partial class ProductsTableAdapter : global::System.ComponentModel.Component {

        

        private global::System.Data.SqlClient.SqlDataAdapter _adapter;

        

        private global::System.Data.SqlClient.SqlConnection _connection;

        

        private global::System.Data.SqlClient.SqlCommand[] _commandCollection;

        

        private bool _clearBeforeFill;

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        public ProductsTableAdapter() {

            this.ClearBeforeFill = true;

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        private global::System.Data.SqlClient.SqlDataAdapter Adapter {

            get {

                if ((this._adapter == null)) {

                    this.InitAdapter();

                }

                return this._adapter;

            }

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        internal global::System.Data.SqlClient.SqlConnection Connection {

            get {

                if ((this._connection == null)) {

                    this.InitConnection();

                }

                return this._connection;

            }

            set {

                this._connection = value;

                if ((this.Adapter.InsertCommand != null)) {

                    this.Adapter.InsertCommand.Connection = value;

                }

                if ((this.Adapter.DeleteCommand != null)) {

                    this.Adapter.DeleteCommand.Connection = value;

                }

                if ((this.Adapter.UpdateCommand != null)) {

                    this.Adapter.UpdateCommand.Connection = value;

                }

                for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {

                    if ((this.CommandCollection[i] != null)) {

                        ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[i])).Connection = value;

                    }

                }

            }

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        protected global::System.Data.SqlClient.SqlCommand[] CommandCollection {

            get {

                if ((this._commandCollection == null)) {

                    this.InitCommandCollection();

                }

                return this._commandCollection;

            }

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        public bool ClearBeforeFill {

            get {

                return this._clearBeforeFill;

            }

            set {

                this._clearBeforeFill = value;

            }

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        private void InitAdapter() {

            this._adapter = new global::System.Data.SqlClient.SqlDataAdapter();

            global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();

            tableMapping.SourceTable = "Table";

            tableMapping.DataSetTable = "Products";

            tableMapping.ColumnMappings.Add("Product ID", "Product ID");

            tableMapping.ColumnMappings.Add("Product Name", "Product Name");

            tableMapping.ColumnMappings.Add("Product Description", "Product Description");

            this._adapter.TableMappings.Add(tableMapping);

            this._adapter.InsertCommand = new global::System.Data.SqlClient.SqlCommand();

            this._adapter.InsertCommand.Connection = this.Connection;

            this._adapter.InsertCommand.CommandText = "INSERT INTO [dbo].[Products] ([Product ID], [Product Name], [Product Description]" +

                ") VALUES (@Product_ID, @Product_Name, @Product_Description)";

            this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;

            this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Product_ID", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Product ID", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));

            this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Product_Name", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Product Name", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));

            this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Product_Description", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "Product Description", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        private void InitConnection() {

            this._connection = new global::System.Data.SqlClient.SqlConnection();

            this._connection.ConnectionString = global::ReportFromSqlServer.Properties.Settings.Default.example_dbConnectionString;

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        private void InitCommandCollection() {

            this._commandCollection = new global::System.Data.SqlClient.SqlCommand[1];

            this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();

            this._commandCollection[0].Connection = this.Connection;

            this._commandCollection[0].CommandText = "SELECT [Product ID], [Product Name], [Product Description] FROM dbo.Products";

            this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]

        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)]

        public virtual int Fill(DataSet1.ProductsDataTable dataTable) {

            this.Adapter.SelectCommand = this.CommandCollection[0];

            if ((this.ClearBeforeFill == true)) {

                dataTable.Clear();

            }

            int returnValue = this.Adapter.Fill(dataTable);

            return returnValue;

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]

        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)]

        public virtual DataSet1.ProductsDataTable GetData() {

            this.Adapter.SelectCommand = this.CommandCollection[0];

            DataSet1.ProductsDataTable dataTable = new DataSet1.ProductsDataTable();

            this.Adapter.Fill(dataTable);

            return dataTable;

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]

        public virtual int Update(DataSet1.ProductsDataTable dataTable) {

            return this.Adapter.Update(dataTable);

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]

        public virtual int Update(DataSet1 dataSet) {

            return this.Adapter.Update(dataSet, "Products");

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]

        public virtual int Update(global::System.Data.DataRow dataRow) {

            return this.Adapter.Update(new global::System.Data.DataRow[] {

                        dataRow});

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]

        public virtual int Update(global::System.Data.DataRow[] dataRows) {

            return this.Adapter.Update(dataRows);

        }

        

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]

        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)]

        public virtual int Insert(global::System.Nullable<int> Product_ID, string Product_Name, string Product_Description) {

            if ((Product_ID.HasValue == true)) {

                this.Adapter.InsertCommand.Parameters[0].Value = ((int)(Product_ID.Value));

            }

            else {

                this.Adapter.InsertCommand.Parameters[0].Value = global::System.DBNull.Value;

            }

            if ((Product_Name == null)) {

                this.Adapter.InsertCommand.Parameters[1].Value = global::System.DBNull.Value;

            }

            else {

                this.Adapter.InsertCommand.Parameters[1].Value = ((string)(Product_Name));

            }

            if ((Product_Description == null)) {

                this.Adapter.InsertCommand.Parameters[2].Value = global::System.DBNull.Value;

            }

            else {

                this.Adapter.InsertCommand.Parameters[2].Value = ((string)(Product_Description));

            }

            global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;

            if (((this.Adapter.InsertCommand.Connection.State & global::System.Data.ConnectionState.Open) 

                        != global::System.Data.ConnectionState.Open)) {

                this.Adapter.InsertCommand.Connection.Open();

            }

            try {

                int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();

                return returnValue;

            }

            finally {

                if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {

                    this.Adapter.InsertCommand.Connection.Close();

                }

            }

        }

    }

}



#pragma warning restore 1591


DataSet1.xsc
<?xml version="1.0" encoding="utf-8"?>
<!--<autogenerated>
     This code was generated by a tool.
     Changes to this file may cause incorrect behavior and will be lost if
     the code is regenerated.
</autogenerated>-->
<DataSetUISetting Version="1.00" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
  <TableUISettings>
  </TableUISettings>
</DataSetUISetting>
DataSet1.xsd
<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DataSet1" targetNamespace="http://tempuri.org/DataSet1.xsd" xmlns:mstns="http://tempuri.org/DataSet1.xsd" xmlns="http://tempuri.org/DataSet1.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="example_dbConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="example_dbConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ReportFromSqlServer.Properties.Settings.GlobalReference.Default.example_dbConnectionString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductsTableAdapter" GeneratorDataComponentClassName="ProductsTableAdapter" Name="Products" UserDataComponentName="ProductsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="example_dbConnectionString (Settings)" DbObjectName="example_db.dbo.Products" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[Products] ([Product ID], [Product Name], [Product Description]) VALUES (@Product_ID, @Product_Name, @Product_Description)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Product_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Product ID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Product_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Product Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Product_Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Product Description" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT [Product ID], [Product Name], [Product Description] FROM dbo.Products</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Product ID" DataSetColumn="Product ID" />
              <Mapping SourceColumn="Product Name" DataSetColumn="Product Name" />
              <Mapping SourceColumn="Product Description" DataSetColumn="Product Description" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DataSet1" msprop:Generator_DataSetName="DataSet1">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Products" msprop:Generator_UserTableName="Products" msprop:Generator_RowDeletedName="ProductsRowDeleted" msprop:Generator_RowChangedName="ProductsRowChanged" msprop:Generator_RowClassName="ProductsRow" msprop:Generator_RowChangingName="ProductsRowChanging" msprop:Generator_RowEvArgName="ProductsRowChangeEvent" msprop:Generator_RowEvHandlerName="ProductsRowChangeEventHandler" msprop:Generator_TableClassName="ProductsDataTable" msprop:Generator_TableVarName="tableProducts" msprop:Generator_RowDeletingName="ProductsRowDeleting" msprop:Generator_TablePropName="Products">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Product_x0020_ID" msprop:Generator_UserColumnName="Product ID" msprop:Generator_ColumnVarNameInTable="columnProduct_ID" msprop:Generator_ColumnPropNameInRow="Product_ID" msprop:Generator_ColumnPropNameInTable="Product_IDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Product_x0020_Name" msprop:Generator_UserColumnName="Product Name" msprop:Generator_ColumnVarNameInTable="columnProduct_Name" msprop:Generator_ColumnPropNameInRow="Product_Name" msprop:Generator_ColumnPropNameInTable="Product_NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Product_x0020_Description" msprop:Generator_UserColumnName="Product Description" msprop:Generator_ColumnVarNameInTable="columnProduct_Description" msprop:Generator_ColumnPropNameInRow="Product_Description" msprop:Generator_ColumnPropNameInTable="Product_DescriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BarCode" msprop:Generator_UserColumnName="BarCode" msprop:Generator_ColumnVarNameInTable="columnBarCode" msprop:Generator_ColumnPropNameInRow="BarCode" msprop:Generator_ColumnPropNameInTable="BarCodeColumn" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>
DataSet1.xss
<?xml version="1.0" encoding="utf-8"?>
<!--<autogenerated>
     This code was generated by a tool to store the dataset designer's layout information.
     Changes to this file may cause incorrect behavior and will be lost if
     the code is regenerated.
</autogenerated>-->
<DiagramLayout xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" ex:showrelationlabel="False" ViewPortX="0" ViewPortY="0" xmlns:ex="urn:schemas-microsoft-com:xml-msdatasource-layout-extended" xmlns="urn:schemas-microsoft-com:xml-msdatasource-layout">
  <Shapes>
    <Shape ID="DesignTable:Products" ZOrder="1" X="232" Y="126" Height="153" Width="196" AdapterExpanded="true" DataTableExpanded="true" OldAdapterHeight="0" OldDataTableHeight="0" SplitterPosition="102" />
  </Shapes>
  <Connectors />
</DiagramLayout>
Form1.Designer.cs
��namespace ReportFromSqlServer

{

	partial class Form1

	{

		private System.ComponentModel.IContainer components = null;



		protected override void Dispose(bool disposing)

		{

			if (disposing && (components != null))

			{

				components.Dispose();

			}

			base.Dispose(disposing);

		}



		#region Windows Form Designer generated code



		private void InitializeComponent()

		{

			this.crystalReportViewer1 = new CrystalDecisions.Windows.Forms.CrystalReportViewer();

			this.CrystalReport11 = new ReportFromSqlServer.CrystalReport1();

			this.SuspendLayout();

			// 

			// crystalReportViewer1

			// 

			this.crystalReportViewer1.ActiveViewIndex = 0;

			this.crystalReportViewer1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;

			this.crystalReportViewer1.Dock = System.Windows.Forms.DockStyle.Fill;

			this.crystalReportViewer1.Location = new System.Drawing.Point(0, 0);

			this.crystalReportViewer1.Name = "crystalReportViewer1";

			this.crystalReportViewer1.ReportSource = this.CrystalReport11;

			this.crystalReportViewer1.Size = new System.Drawing.Size(799, 566);

			this.crystalReportViewer1.TabIndex = 0;

			// 

			// Form1

			// 

			this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);

			this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;

			this.ClientSize = new System.Drawing.Size(799, 566);

			this.Controls.Add(this.crystalReportViewer1);

			this.Name = "Form1";

			this.Text = "Form1";

			this.ResumeLayout(false);



		}



		#endregion



		private CrystalDecisions.Windows.Forms.CrystalReportViewer crystalReportViewer1;

		private CrystalReport1 CrystalReport11;





	}

}




Form1.cs
using System;
using System.Data;
using System.Diagnostics;
using System.Windows.Forms;
using System.Data.SqlClient;
using Bytescout.BarCode;

namespace ReportFromSqlServer
{
	public partial class Form1 : Form
	{
		public Form1()
		{
			InitializeComponent();

			try
			{
				// MODIFY THE CONNECTION STRING WITH YOUR SERVER CONNECTION INFO!!!
				const string connectionString = "Data Source=localhost\\SQLEXPRESS;Initial Catalog=master;Integrated Security=true;";

				using (SqlConnection connection = new SqlConnection(connectionString))
				{
					connection.Open();

					// Create a database for demonstration purposes
					///////////////////////////////////////////////////////////////////////////////////////

					Object o = ExecuteQueryScalar(connection, "SELECT DB_ID('example_db')");

					// if 'example_db' does not exist, create it
					if (o == null || o is DBNull)
					{
						// Create empty database
						ExecuteQueryWithoutResult(connection, "CREATE DATABASE example_db");
						// Switch to created database
						ExecuteQueryWithoutResult(connection, "USE example_db");
						// Create a table
						ExecuteQueryWithoutResult(connection, "CREATE TABLE Products ([Product ID] int, [Product Name] nvarchar(100), [Product Description] nvarchar(255))");
						// Fill the table with data
						ExecuteQueryWithoutResult(connection, "INSERT Products VALUES(1, 'Spreadsheet Tools', 'Convert XLS, XLSX, CSV, ODS spreadsheet into HTML, PDF, XLS, XLSX, CSV formats WITHOUT EXCEL installed')");
						ExecuteQueryWithoutResult(connection, "INSERT Products VALUES(2, 'Watermarking PRO', 'Professional tool to protect images: multiple watermarks, custom position for watermarks, image effects, EXIF and IPTC macros for text and more')");
						ExecuteQueryWithoutResult(connection, "INSERT Products VALUES(3, 'Watermarking', 'Protect copyrights for your images with professional looking watermarks with this easy to use tool')");
						ExecuteQueryWithoutResult(connection, "INSERT Products VALUES(4, 'PPT To Video Scout', 'converts PowerPoint presentations (PPT, PPTX) into AVI,MPEG,WMV, FLV (flash video) video movies with sound')");
					}


					// Create a datataset from query.
					// Query result columns must conform to field names we used in the report designer

					SqlDataAdapter dataAdapter = new SqlDataAdapter("SELECT [Product ID], [Product Name], [Product Description] FROM example_db.dbo.Products", connection);

					// fill dataset
					DataSet dataSet = new DataSet();
					dataAdapter.Fill(dataSet);

					// don't forget to close the connection
					connection.Close();

					// add virtual column into the result table
					dataSet.Tables[0].Columns.Add(new DataColumn("BarCode", typeof(byte[])));

					// create barcode object
					Barcode bc = new Barcode(SymbologyType.Code39);
					bc.DrawCaption = false;

					foreach (DataRow row in dataSet.Tables[0].Rows)
					{
						// set barcode value
						bc.Value = (Convert.ToString(row["Product ID"]));

						// retrieve generated image bytes
						byte[] barcodeBytes = bc.GetImageBytesWMF();

						// fill virtual column with generated image bytes
						row["BarCode"] = barcodeBytes;
					}

					// set report datasource
					CrystalReport11.SetDataSource(dataSet.Tables[0]);
				}
			}
			catch (Exception ex)
			{
				Trace.WriteLine("Error: " + ex.Message);
			}
		}

		private static void ExecuteQueryWithoutResult(SqlConnection connection, string query)
		{
			using (SqlCommand command = new SqlCommand(query, connection))
			{
				command.ExecuteNonQuery();
			}
		}

		private static object ExecuteQueryScalar(SqlConnection connection, string query)
		{
			using (SqlCommand command = new SqlCommand(query, connection))
			{
				return command.ExecuteScalar();
			}
		}
	}
}

Program.cs
using System;
using System.Collections.Generic;
using System.Windows.Forms;

namespace ReportFromSqlServer
{
	static class Program
	{
		[STAThread]
		static void Main()
		{
			Application.EnableVisualStyles();
			Application.Run(new Form1());
		}
	}
}

Resources.Designer.cs
��//------------------------------------------------------------------------------

// <auto-generated>

//     This code was generated by a tool.

//     Runtime Version:2.0.50727.4927

//

//     Changes to this file may cause incorrect behavior and will be lost if

//     the code is regenerated.

// </auto-generated>

//------------------------------------------------------------------------------



namespace ReportFromSqlServer.Properties {

    using System;

    

    

    /// <summary>

    ///   A strongly-typed resource class, for looking up localized strings, etc.

    /// </summary>

    // This class was auto-generated by the StronglyTypedResourceBuilder

    // class via a tool like ResGen or Visual Studio.

    // To add or remove a member, edit your .ResX file then rerun ResGen

    // with the /str option, or rebuild your VS project.

    [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Resources.Tools.StronglyTypedResourceBuilder", "2.0.0.0")]

    [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

    [global::System.Runtime.CompilerServices.CompilerGeneratedAttribute()]

    internal class Resources {

        

        private static global::System.Resources.ResourceManager resourceMan;

        

        private static global::System.Globalization.CultureInfo resourceCulture;

        

        [global::System.Diagnostics.CodeAnalysis.SuppressMessageAttribute("Microsoft.Performance", "CA1811:AvoidUncalledPrivateCode")]

        internal Resources() {

        }

        

        /// <summary>

        ///   Returns the cached ResourceManager instance used by this class.

        /// </summary>

        [global::System.ComponentModel.EditorBrowsableAttribute(global::System.ComponentModel.EditorBrowsableState.Advanced)]

        internal static global::System.Resources.ResourceManager ResourceManager {

            get {

                if (object.ReferenceEquals(resourceMan, null)) {

                    global::System.Resources.ResourceManager temp = new global::System.Resources.ResourceManager("ReportFromSqlServer.Properties.Resources", typeof(Resources).Assembly);

                    resourceMan = temp;

                }

                return resourceMan;

            }

        }

        

        /// <summary>

        ///   Overrides the current thread's CurrentUICulture property for all

        ///   resource lookups using this strongly typed resource class.

        /// </summary>

        [global::System.ComponentModel.EditorBrowsableAttribute(global::System.ComponentModel.EditorBrowsableState.Advanced)]

        internal static global::System.Globalization.CultureInfo Culture {

            get {

                return resourceCulture;

            }

            set {

                resourceCulture = value;

            }

        }

    }

}


Settings.Designer.cs
��//------------------------------------------------------------------------------

// <auto-generated>

//     This code was generated by a tool.

//     Runtime Version:2.0.50727.4927

//

//     Changes to this file may cause incorrect behavior and will be lost if

//     the code is regenerated.

// </auto-generated>

//------------------------------------------------------------------------------



namespace ReportFromSqlServer.Properties {

    

    

    [global::System.Runtime.CompilerServices.CompilerGeneratedAttribute()]

    [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Editors.SettingsDesigner.SettingsSingleFileGenerator", "8.0.0.0")]

    internal sealed partial class Settings : global::System.Configuration.ApplicationSettingsBase {

        

        private static Settings defaultInstance = ((Settings)(global::System.Configuration.ApplicationSettingsBase.Synchronized(new Settings())));

        

        public static Settings Default {

            get {

                return defaultInstance;

            }

        }

        

        [global::System.Configuration.ApplicationScopedSettingAttribute()]

        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]

        [global::System.Configuration.SpecialSettingAttribute(global::System.Configuration.SpecialSetting.ConnectionString)]

        [global::System.Configuration.DefaultSettingValueAttribute("Data Source=STARKOV\\SQLEXPRESS;Initial Catalog=example_db;Integrated Security=Tru" +

            "e")]

        public string example_dbConnectionString {

            get {

                return ((string)(this["example_dbConnectionString"]));

            }

        }

    }

}


Download Source Code (.zip)

Return to the previous page Explore BarCode SDK


Copyright © 2016 - 2021 ByteScout