This is a migrated thread and some comments may be shown as answers.

Report runs when I hard code the parm in the sql, but not when I pass a value in program.

1 Answer 82 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
IQworks
Top achievements
Rank 1
IQworks asked on 12 Sep 2009, 03:21 AM
 Hi,
   I am new to telerik reporting.
   I went through the wizard and I get data in my report. But when I try to use a parm I get
"An error has occured while processing TextBox 'eqMemberNoDataTextBox 1':
Index was out of range. Must be non-negative and less than the size of the collection."

Now I dont know if I missed a step or need a step.
Here is where I call my report ...
<%@ Control Language="C#" ClassName="iqReport_Viewer" %> 
<%@ Register Assembly="Telerik.ReportViewer.WebForms, Version=3.0.9.430, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" 
    Namespace="Telerik.ReportViewer.WebForms" TagPrefix="telerik" %> 
 
<script runat="server">  
 
    protected void Page_Load(object sender, EventArgs e)  
        {  
        if (!IsPostBack)  
            {  
            //  iqReports_lib.iqRPT_Equipment equipRPT = new iqReports_lib.iqRPT_Equipment();  
            iqReports_lib.iqEquipment_Summary equipRPT = new iqReports_lib.iqEquipment_Summary();  
            //report1.DataSource = MyDataSource;  
            string ds = equipRPT.DataSource.ToString();  
            string dm = equipRPT.DataMember.ToString();  
            equipRPT.ReportParameters["MemberParm"].Value = 2;   
            ReportViewer1.Report = equipRPT;  
            //(ReportViewer1.Report as equipRPT).ReportParameters[0].Value = "3";     
            }  
        }  
      
      
      
</script> 
 
<telerik:ReportViewer ID="ReportViewer1" runat="server" Skin="WebBlue" Width="900px" 
    Height="500px" BorderWidth="5px">  
    <Resources ProcessingReportMessage="Generating MBS report..." /> 
</telerik:ReportViewer> 
 

Here is my iqEquipment_Summary.cs Report
namespace iqReports_lib  
    {  
    using System;  
    using System.ComponentModel;  
    using System.Drawing;  
    using System.Windows.Forms;  
    using Telerik.Reporting;  
    using Telerik.Reporting.Drawing;  
 
    /// <summary> 
    /// Summary description for iqEquipment_Summary.  
    /// </summary> 
    public partial class iqEquipment_Summary : Telerik.Reporting.Report  
        {  
        public iqEquipment_Summary()  
            {  
            /// <summary> 
            /// Required for telerik Reporting designer support  
            /// </summary> 
            InitializeComponent();  
 
            //  
            // TODO: Add any constructor code after InitializeComponent call  
            //  
 
            // TODO: This line of code loads data into the 'iqBodyWorksV02DataSetEquipmentSummary.iqBodyWorksV02DataSetEquipmentSummaryTable' table. You can move, or remove it, as needed.  
            try  
                {  
                this.iqBodyWorksV02DataSetEquipmentSummaryTableAdapter1.Fill(this.iqBodyWorksV02DataSetEquipmentSummary.iqBodyWorksV02DataSetEquipmentSummaryTable);  
                }  
            catch (System.Exception ex)  
                {  
                // An error has occurred while filling the data set. Please check the exception for more information.  
                System.Diagnostics.Debug.WriteLine(ex.Message);  
                }  
 
            // TODO: This line of code loads data into the 'iqBodyWorksV02DataSetEquipmentSummary.iqBodyWorksV02DataSetEquipmentSummaryTable' table. You can move, or remove it, as needed.  
            try  
                {  
                this.iqBodyWorksV02DataSetEquipmentSummaryTableAdapter1.Fill(this.iqBodyWorksV02DataSetEquipmentSummary.iqBodyWorksV02DataSetEquipmentSummaryTable);  
                }  
            catch (System.Exception ex)  
                {  
                // An error has occurred while filling the data set. Please check the exception for more information.  
                System.Diagnostics.Debug.WriteLine(ex.Message);  
                }  
 
            // TODO: This line of code loads data into the 'iqBodyWorksV02DataSetEquipmentSummary.iqBodyWorksV02DataSetEquipmentSummaryTable' table. You can move, or remove it, as needed.  
            try  
            {  
                this.iqBodyWorksV02DataSetEquipmentSummaryTableAdapter1.Fill(this.iqBodyWorksV02DataSetEquipmentSummary.iqBodyWorksV02DataSetEquipmentSummaryTable);  
            }  
            catch (System.Exception ex)  
            {  
                // An error has occurred while filling the data set. Please check the exception for more information.  
                System.Diagnostics.Debug.WriteLine(ex.Message);  
            }  
 
            // TODO: This line of code loads data into the 'iqBodyWorksV02DataSetEquipmentSummary.iqBodyWorksV02DataSetEquipmentSummaryTable' table. You can move, or remove it, as needed.  
            try  
            {  
                this.iqBodyWorksV02DataSetEquipmentSummaryTableAdapter1.Fill(this.iqBodyWorksV02DataSetEquipmentSummary.iqBodyWorksV02DataSetEquipmentSummaryTable);  
            }  
            catch (System.Exception ex)  
            {  
                // An error has occurred while filling the data set. Please check the exception for more information.  
                System.Diagnostics.Debug.WriteLine(ex.Message);  
            }  
 
            // TODO: This line of code loads data into the 'iqBodyWorksV02DataSetEquipmentSummary.iqBodyWorksV02DataSetEquipmentSummaryTable' table. You can move, or remove it, as needed.  
            try  
            {  
                this.iqBodyWorksV02DataSetEquipmentSummaryTableAdapter1.Fill(this.iqBodyWorksV02DataSetEquipmentSummary.iqBodyWorksV02DataSetEquipmentSummaryTable);  
            }  
            catch (System.Exception ex)  
            {  
                // An error has occurred while filling the data set. Please check the exception for more information.  
                System.Diagnostics.Debug.WriteLine(ex.Message);  
            }  
 
            // TODO: This line of code loads data into the 'iqBodyWorksV02DataSetEquipmentSummary.iqBodyWorksV02DataSetEquipmentSummaryTable' table. You can move, or remove it, as needed.  
            try  
            {  
                this.iqBodyWorksV02DataSetEquipmentSummaryTableAdapter1.Fill(this.iqBodyWorksV02DataSetEquipmentSummary.iqBodyWorksV02DataSetEquipmentSummaryTable);  
            }  
            catch (System.Exception ex)  
            {  
                // An error has occurred while filling the data set. Please check the exception for more information.  
                System.Diagnostics.Debug.WriteLine(ex.Message);  
            }  
 
            // TODO: This line of code loads data into the 'iqBodyWorksV02DataSetEquipmentSummary.iqBodyWorksV02DataSetEquipmentSummaryTable' table. You can move, or remove it, as needed.  
            try  
            {  
                this.iqBodyWorksV02DataSetEquipmentSummaryTableAdapter1.Fill(this.iqBodyWorksV02DataSetEquipmentSummary.iqBodyWorksV02DataSetEquipmentSummaryTable);  
            }  
            catch (System.Exception ex)  
            {  
                // An error has occurred while filling the data set. Please check the exception for more information.  
                System.Diagnostics.Debug.WriteLine(ex.Message);  
            }  
            }  
        }  
    } 


Here is my XSD designer.cs
/------------------------------------------------------------------------------  
// <auto-generated> 
//     This code was generated by a tool.  
//     Runtime Version:2.0.50727.3082  
//  
//     Changes to this file may cause incorrect behavior and will be lost if  
//     the code is regenerated.  
// </auto-generated> 
//------------------------------------------------------------------------------  
 
#pragma warning disable 1591  
 
namespace iqReports_lib {  
      
      
    /// <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("iqBodyWorksV02DataSetEquipmentSummary")]  
    [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.DataSet")]  
    public partial class iqBodyWorksV02DataSetEquipmentSummary : global::System.Data.DataSet {  
          
        private iqBodyWorksV02DataSetEquipmentSummaryTableDataTable tableiqBodyWorksV02DataSetEquipmentSummaryTable;  
          
        private DataTable1DataTable tableDataTable1;  
          
        private global::System.Data.SchemaSerializationMode _schemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;  
          
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
        public iqBodyWorksV02DataSetEquipmentSummary() {  
            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 iqBodyWorksV02DataSetEquipmentSummary(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["iqBodyWorksV02DataSetEquipmentSummaryTable"] != null)) {  
                    base.Tables.Add(new iqBodyWorksV02DataSetEquipmentSummaryTableDataTable(ds.Tables["iqBodyWorksV02DataSetEquipmentSummaryTable"]));  
                }  
                if ((ds.Tables["DataTable1"] != null)) {  
                    base.Tables.Add(new DataTable1DataTable(ds.Tables["DataTable1"]));  
                }  
                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 iqBodyWorksV02DataSetEquipmentSummaryTableDataTable iqBodyWorksV02DataSetEquipmentSummaryTable {  
            get {  
                return this.tableiqBodyWorksV02DataSetEquipmentSummaryTable;  
            }  
        }  
          
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
        [global::System.ComponentModel.Browsable(false)]  
        [global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)]  
        public DataTable1DataTable DataTable1 {  
            get {  
                return this.tableDataTable1;  
            }  
        }  
          
        [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() {  
            iqBodyWorksV02DataSetEquipmentSummary cln = ((iqBodyWorksV02DataSetEquipmentSummary)(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["iqBodyWorksV02DataSetEquipmentSummaryTable"] != null)) {  
                    base.Tables.Add(new iqBodyWorksV02DataSetEquipmentSummaryTableDataTable(ds.Tables["iqBodyWorksV02DataSetEquipmentSummaryTable"]));  
                }  
                if ((ds.Tables["DataTable1"] != null)) {  
                    base.Tables.Add(new DataTable1DataTable(ds.Tables["DataTable1"]));  
                }  
                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.tableiqBodyWorksV02DataSetEquipmentSummaryTable = ((iqBodyWorksV02DataSetEquipmentSummaryTableDataTable)(base.Tables["iqBodyWorksV02DataSetEquipmentSummaryTable"]));  
            if ((initTable == true)) {  
                if ((this.tableiqBodyWorksV02DataSetEquipmentSummaryTable != null)) {  
                    this.tableiqBodyWorksV02DataSetEquipmentSummaryTable.InitVars();  
                }  
            }  
            this.tableDataTable1 = ((DataTable1DataTable)(base.Tables["DataTable1"]));  
            if ((initTable == true)) {  
                if ((this.tableDataTable1 != null)) {  
                    this.tableDataTable1.InitVars();  
                }  
            }  
        }  
          
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
        private void InitClass() {  
            this.DataSetName = "iqBodyWorksV02DataSetEquipmentSummary";  
            this.Prefix = "";  
            this.EnforceConstraints = true;  
            this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;  
            this.tableiqBodyWorksV02DataSetEquipmentSummaryTable = new iqBodyWorksV02DataSetEquipmentSummaryTableDataTable();  
            base.Tables.Add(this.tableiqBodyWorksV02DataSetEquipmentSummaryTable);  
            this.tableDataTable1 = new DataTable1DataTable();  
            base.Tables.Add(this.tableDataTable1);  
        }  
          
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
        private bool ShouldSerializeiqBodyWorksV02DataSetEquipmentSummaryTable() {  
            return false;  
        }  
          
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
        private bool ShouldSerializeDataTable1() {  
            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) {  
            iqBodyWorksV02DataSetEquipmentSummary ds = new iqBodyWorksV02DataSetEquipmentSummary();  
            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 dsdsSchema = 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 iqBodyWorksV02DataSetEquipmentSummaryTableRowChangeEventHandler(object sender, iqBodyWorksV02DataSetEquipmentSummaryTableRowChangeEvent e);  
          
        public delegate void DataTable1RowChangeEventHandler(object sender, DataTable1RowChangeEvent 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 iqBodyWorksV02DataSetEquipmentSummaryTableDataTable : global::System.Data.TypedTableBase<iqBodyWorksV02DataSetEquipmentSummaryTableRow> {  
              
            private global::System.Data.DataColumn columneqEquipmentNo;  
              
            private global::System.Data.DataColumn columneqEquipmentName;  
              
            private global::System.Data.DataColumn columnloLocation;  
              
            private global::System.Data.DataColumn columnloDescription;  
              
            private global::System.Data.DataColumn columnmbUserName;  
              
            private global::System.Data.DataColumn columntpTypeName;  
              
            private global::System.Data.DataColumn columntpTypeDescription;  
              
            private global::System.Data.DataColumn columneqEquipmentTypeNo;  
              
            private global::System.Data.DataColumn columntpTypeCode;  
              
            private global::System.Data.DataColumn columneqMemberNo;  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public iqBodyWorksV02DataSetEquipmentSummaryTableDataTable() {  
                this.TableName = "iqBodyWorksV02DataSetEquipmentSummaryTable";  
                this.BeginInit();  
                this.InitClass();  
                this.EndInit();  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            internal iqBodyWorksV02DataSetEquipmentSummaryTableDataTable(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 iqBodyWorksV02DataSetEquipmentSummaryTableDataTable(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 eqEquipmentNoColumn {  
                get {  
                    return this.columneqEquipmentNo;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataColumn eqEquipmentNameColumn {  
                get {  
                    return this.columneqEquipmentName;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataColumn loLocationColumn {  
                get {  
                    return this.columnloLocation;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataColumn loDescriptionColumn {  
                get {  
                    return this.columnloDescription;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataColumn mbUserNameColumn {  
                get {  
                    return this.columnmbUserName;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataColumn tpTypeNameColumn {  
                get {  
                    return this.columntpTypeName;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataColumn tpTypeDescriptionColumn {  
                get {  
                    return this.columntpTypeDescription;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataColumn eqEquipmentTypeNoColumn {  
                get {  
                    return this.columneqEquipmentTypeNo;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataColumn tpTypeCodeColumn {  
                get {  
                    return this.columntpTypeCode;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataColumn eqMemberNoColumn {  
                get {  
                    return this.columneqMemberNo;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            [global::System.ComponentModel.Browsable(false)]  
            public int Count {  
                get {  
                    return this.Rows.Count;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public iqBodyWorksV02DataSetEquipmentSummaryTableRow this[int index] {  
                get {  
                    return ((iqBodyWorksV02DataSetEquipmentSummaryTableRow)(this.Rows[index]));  
                }  
            }  
              
            public event iqBodyWorksV02DataSetEquipmentSummaryTableRowChangeEventHandler iqBodyWorksV02DataSetEquipmentSummaryTableRowChanging;  
              
            public event iqBodyWorksV02DataSetEquipmentSummaryTableRowChangeEventHandler iqBodyWorksV02DataSetEquipmentSummaryTableRowChanged;  
              
            public event iqBodyWorksV02DataSetEquipmentSummaryTableRowChangeEventHandler iqBodyWorksV02DataSetEquipmentSummaryTableRowDeleting;  
              
            public event iqBodyWorksV02DataSetEquipmentSummaryTableRowChangeEventHandler iqBodyWorksV02DataSetEquipmentSummaryTableRowDeleted;  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public void AddiqBodyWorksV02DataSetEquipmentSummaryTableRow(iqBodyWorksV02DataSetEquipmentSummaryTableRow row) {  
                this.Rows.Add(row);  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public iqBodyWorksV02DataSetEquipmentSummaryTableRow AddiqBodyWorksV02DataSetEquipmentSummaryTableRow(int eqEquipmentNo, string eqEquipmentName, string loLocation, string loDescription, string mbUserName, string tpTypeName, string tpTypeDescription, int eqEquipmentTypeNo, string tpTypeCode, int eqMemberNo) {  
                iqBodyWorksV02DataSetEquipmentSummaryTableRow rowiqBodyWorksV02DataSetEquipmentSummaryTableRow = ((iqBodyWorksV02DataSetEquipmentSummaryTableRow)(this.NewRow()));  
                object[] columnValuesArray = new object[] {  
                        eqEquipmentNo,  
                        eqEquipmentName,  
                        loLocation,  
                        loDescription,  
                        mbUserName,  
                        tpTypeName,  
                        tpTypeDescription,  
                        eqEquipmentTypeNo,  
                        tpTypeCode,  
                        eqMemberNo};  
                rowiqBodyWorksV02DataSetEquipmentSummaryTableRow.ItemArray = columnValuesArray;  
                this.Rows.Add(rowiqBodyWorksV02DataSetEquipmentSummaryTableRow);  
                return rowiqBodyWorksV02DataSetEquipmentSummaryTableRow;  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public override global::System.Data.DataTable Clone() {  
                iqBodyWorksV02DataSetEquipmentSummaryTableDataTable cln = ((iqBodyWorksV02DataSetEquipmentSummaryTableDataTable)(base.Clone()));  
                cln.InitVars();  
                return cln;  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            protected override global::System.Data.DataTable CreateInstance() {  
                return new iqBodyWorksV02DataSetEquipmentSummaryTableDataTable();  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            internal void InitVars() {  
                this.columneqEquipmentNo = base.Columns["eqEquipmentNo"];  
                this.columneqEquipmentName = base.Columns["eqEquipmentName"];  
                this.columnloLocation = base.Columns["loLocation"];  
                this.columnloDescription = base.Columns["loDescription"];  
                this.columnmbUserName = base.Columns["mbUserName"];  
                this.columntpTypeName = base.Columns["tpTypeName"];  
                this.columntpTypeDescription = base.Columns["tpTypeDescription"];  
                this.columneqEquipmentTypeNo = base.Columns["eqEquipmentTypeNo"];  
                this.columntpTypeCode = base.Columns["tpTypeCode"];  
                this.columneqMemberNo = base.Columns["eqMemberNo"];  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            private void InitClass() {  
                this.columneqEquipmentNo = new global::System.Data.DataColumn("eqEquipmentNo", typeof(int), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columneqEquipmentNo);  
                this.columneqEquipmentName = new global::System.Data.DataColumn("eqEquipmentName", typeof(string), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columneqEquipmentName);  
                this.columnloLocation = new global::System.Data.DataColumn("loLocation", typeof(string), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columnloLocation);  
                this.columnloDescription = new global::System.Data.DataColumn("loDescription", typeof(string), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columnloDescription);  
                this.columnmbUserName = new global::System.Data.DataColumn("mbUserName", typeof(string), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columnmbUserName);  
                this.columntpTypeName = new global::System.Data.DataColumn("tpTypeName", typeof(string), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columntpTypeName);  
                this.columntpTypeDescription = new global::System.Data.DataColumn("tpTypeDescription", typeof(string), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columntpTypeDescription);  
                this.columneqEquipmentTypeNo = new global::System.Data.DataColumn("eqEquipmentTypeNo", typeof(int), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columneqEquipmentTypeNo);  
                this.columntpTypeCode = new global::System.Data.DataColumn("tpTypeCode", typeof(string), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columntpTypeCode);  
                this.columneqMemberNo = new global::System.Data.DataColumn("eqMemberNo", typeof(int), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columneqMemberNo);  
                this.columneqEquipmentNo.AllowDBNull = false;  
                this.columneqEquipmentName.AllowDBNull = false;  
                this.columneqEquipmentName.MaxLength = 50;  
                this.columnloLocation.AllowDBNull = false;  
                this.columnloLocation.MaxLength = 25;  
                this.columnloDescription.AllowDBNull = false;  
                this.columnloDescription.MaxLength = 50;  
                this.columnmbUserName.AllowDBNull = false;  
                this.columnmbUserName.MaxLength = 25;  
                this.columntpTypeName.AllowDBNull = false;  
                this.columntpTypeName.MaxLength = 25;  
                this.columntpTypeDescription.AllowDBNull = false;  
                this.columntpTypeDescription.MaxLength = 300;  
                this.columneqEquipmentTypeNo.AllowDBNull = false;  
                this.columntpTypeCode.AllowDBNull = false;  
                this.columntpTypeCode.MaxLength = 25;  
                this.columneqMemberNo.AllowDBNull = false;  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public iqBodyWorksV02DataSetEquipmentSummaryTableRow NewiqBodyWorksV02DataSetEquipmentSummaryTableRow() {  
                return ((iqBodyWorksV02DataSetEquipmentSummaryTableRow)(this.NewRow()));  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {  
                return new iqBodyWorksV02DataSetEquipmentSummaryTableRow(builder);  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            protected override global::System.Type GetRowType() {  
                return typeof(iqBodyWorksV02DataSetEquipmentSummaryTableRow);  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {  
                base.OnRowChanged(e);  
                if ((this.iqBodyWorksV02DataSetEquipmentSummaryTableRowChanged != null)) {  
                    this.iqBodyWorksV02DataSetEquipmentSummaryTableRowChanged(this, new iqBodyWorksV02DataSetEquipmentSummaryTableRowChangeEvent(((iqBodyWorksV02DataSetEquipmentSummaryTableRow)(e.Row)), e.Action));  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {  
                base.OnRowChanging(e);  
                if ((this.iqBodyWorksV02DataSetEquipmentSummaryTableRowChanging != null)) {  
                    this.iqBodyWorksV02DataSetEquipmentSummaryTableRowChanging(this, new iqBodyWorksV02DataSetEquipmentSummaryTableRowChangeEvent(((iqBodyWorksV02DataSetEquipmentSummaryTableRow)(e.Row)), e.Action));  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {  
                base.OnRowDeleted(e);  
                if ((this.iqBodyWorksV02DataSetEquipmentSummaryTableRowDeleted != null)) {  
                    this.iqBodyWorksV02DataSetEquipmentSummaryTableRowDeleted(this, new iqBodyWorksV02DataSetEquipmentSummaryTableRowChangeEvent(((iqBodyWorksV02DataSetEquipmentSummaryTableRow)(e.Row)), e.Action));  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {  
                base.OnRowDeleting(e);  
                if ((this.iqBodyWorksV02DataSetEquipmentSummaryTableRowDeleting != null)) {  
                    this.iqBodyWorksV02DataSetEquipmentSummaryTableRowDeleting(this, new iqBodyWorksV02DataSetEquipmentSummaryTableRowChangeEvent(((iqBodyWorksV02DataSetEquipmentSummaryTableRow)(e.Row)), e.Action));  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public void RemoveiqBodyWorksV02DataSetEquipmentSummaryTableRow(iqBodyWorksV02DataSetEquipmentSummaryTableRow 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();  
                iqBodyWorksV02DataSetEquipmentSummary ds = new iqBodyWorksV02DataSetEquipmentSummary();  
                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 = "iqBodyWorksV02DataSetEquipmentSummaryTableDataTable";  
                type.Attributes.Add(attribute2);  
                type.Particle = sequence;  
                global::System.Xml.Schema.XmlSchema dsdsSchema = 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 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 DataTable1DataTable : global::System.Data.TypedTableBase<DataTable1Row> {  
              
            private global::System.Data.DataColumn columnmbMemberNo;  
              
            private global::System.Data.DataColumn columnmbUserName;  
              
            private global::System.Data.DataColumn columneqEquipmentNo;  
              
            private global::System.Data.DataColumn columneqEquipmentLocNo;  
              
            private global::System.Data.DataColumn columneqEquipmentTypeNo;  
              
            private global::System.Data.DataColumn columneqEquipmentName;  
              
            private global::System.Data.DataColumn columneqEquipmentMake;  
              
            private global::System.Data.DataColumn columneqEquipmentModel;  
              
            private global::System.Data.DataColumn columneqEquipmentGymID;  
              
            private global::System.Data.DataColumn columneqEquipmentNotes;  
              
            private global::System.Data.DataColumn columneqDateCreated;  
              
            private global::System.Data.DataColumn columneqDateUpdated;  
              
            private global::System.Data.DataColumn columnloLocation;  
              
            private global::System.Data.DataColumn columnloDescription;  
              
            private global::System.Data.DataColumn columneqMemberNo;  
              
            private global::System.Data.DataColumn columntpTypeName;  
              
            private global::System.Data.DataColumn columntpTypeDescription;  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public DataTable1DataTable() {  
                this.TableName = "DataTable1";  
                this.BeginInit();  
                this.InitClass();  
                this.EndInit();  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            internal DataTable1DataTable(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 DataTable1DataTable(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 mbMemberNoColumn {  
                get {  
                    return this.columnmbMemberNo;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataColumn mbUserNameColumn {  
                get {  
                    return this.columnmbUserName;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataColumn eqEquipmentNoColumn {  
                get {  
                    return this.columneqEquipmentNo;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataColumn eqEquipmentLocNoColumn {  
                get {  
                    return this.columneqEquipmentLocNo;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataColumn eqEquipmentTypeNoColumn {  
                get {  
                    return this.columneqEquipmentTypeNo;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataColumn eqEquipmentNameColumn {  
                get {  
                    return this.columneqEquipmentName;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataColumn eqEquipmentMakeColumn {  
                get {  
                    return this.columneqEquipmentMake;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataColumn eqEquipmentModelColumn {  
                get {  
                    return this.columneqEquipmentModel;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataColumn eqEquipmentGymIDColumn {  
                get {  
                    return this.columneqEquipmentGymID;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataColumn eqEquipmentNotesColumn {  
                get {  
                    return this.columneqEquipmentNotes;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataColumn eqDateCreatedColumn {  
                get {  
                    return this.columneqDateCreated;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataColumn eqDateUpdatedColumn {  
                get {  
                    return this.columneqDateUpdated;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataColumn loLocationColumn {  
                get {  
                    return this.columnloLocation;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataColumn loDescriptionColumn {  
                get {  
                    return this.columnloDescription;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataColumn eqMemberNoColumn {  
                get {  
                    return this.columneqMemberNo;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataColumn tpTypeNameColumn {  
                get {  
                    return this.columntpTypeName;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataColumn tpTypeDescriptionColumn {  
                get {  
                    return this.columntpTypeDescription;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            [global::System.ComponentModel.Browsable(false)]  
            public int Count {  
                get {  
                    return this.Rows.Count;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public DataTable1Row this[int index] {  
                get {  
                    return ((DataTable1Row)(this.Rows[index]));  
                }  
            }  
              
            public event DataTable1RowChangeEventHandler DataTable1RowChanging;  
              
            public event DataTable1RowChangeEventHandler DataTable1RowChanged;  
              
            public event DataTable1RowChangeEventHandler DataTable1RowDeleting;  
              
            public event DataTable1RowChangeEventHandler DataTable1RowDeleted;  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public void AddDataTable1Row(DataTable1Row row) {  
                this.Rows.Add(row);  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public DataTable1Row AddDataTable1Row(  
                        int mbMemberNo,   
                        string mbUserName,   
                        int eqEquipmentNo,   
                        int eqEquipmentLocNo,   
                        int eqEquipmentTypeNo,   
                        string eqEquipmentName,   
                        string eqEquipmentMake,   
                        string eqEquipmentModel,   
                        string eqEquipmentGymID,   
                        string eqEquipmentNotes,   
                        System.DateTime eqDateCreated,   
                        System.DateTime eqDateUpdated,   
                        string loLocation,   
                        string loDescription,   
                        int eqMemberNo,   
                        string tpTypeName,   
                        string tpTypeDescription) {  
                DataTable1Row rowDataTable1Row = ((DataTable1Row)(this.NewRow()));  
                object[] columnValuesArray = new object[] {  
                        mbMemberNo,  
                        mbUserName,  
                        eqEquipmentNo,  
                        eqEquipmentLocNo,  
                        eqEquipmentTypeNo,  
                        eqEquipmentName,  
                        eqEquipmentMake,  
                        eqEquipmentModel,  
                        eqEquipmentGymID,  
                        eqEquipmentNotes,  
                        eqDateCreated,  
                        eqDateUpdated,  
                        loLocation,  
                        loDescription,  
                        eqMemberNo,  
                        tpTypeName,  
                        tpTypeDescription};  
                rowDataTable1Row.ItemArray = columnValuesArray;  
                this.Rows.Add(rowDataTable1Row);  
                return rowDataTable1Row;  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public DataTable1Row FindByeqEquipmentNoeqMemberNo(int eqEquipmentNo, int eqMemberNo) {  
                return ((DataTable1Row)(this.Rows.Find(new object[] {  
                            eqEquipmentNo,  
                            eqMemberNo})));  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public override global::System.Data.DataTable Clone() {  
                DataTable1DataTable cln = ((DataTable1DataTable)(base.Clone()));  
                cln.InitVars();  
                return cln;  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            protected override global::System.Data.DataTable CreateInstance() {  
                return new DataTable1DataTable();  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            internal void InitVars() {  
                this.columnmbMemberNo = base.Columns["mbMemberNo"];  
                this.columnmbUserName = base.Columns["mbUserName"];  
                this.columneqEquipmentNo = base.Columns["eqEquipmentNo"];  
                this.columneqEquipmentLocNo = base.Columns["eqEquipmentLocNo"];  
                this.columneqEquipmentTypeNo = base.Columns["eqEquipmentTypeNo"];  
                this.columneqEquipmentName = base.Columns["eqEquipmentName"];  
                this.columneqEquipmentMake = base.Columns["eqEquipmentMake"];  
                this.columneqEquipmentModel = base.Columns["eqEquipmentModel"];  
                this.columneqEquipmentGymID = base.Columns["eqEquipmentGymID"];  
                this.columneqEquipmentNotes = base.Columns["eqEquipmentNotes"];  
                this.columneqDateCreated = base.Columns["eqDateCreated"];  
                this.columneqDateUpdated = base.Columns["eqDateUpdated"];  
                this.columnloLocation = base.Columns["loLocation"];  
                this.columnloDescription = base.Columns["loDescription"];  
                this.columneqMemberNo = base.Columns["eqMemberNo"];  
                this.columntpTypeName = base.Columns["tpTypeName"];  
                this.columntpTypeDescription = base.Columns["tpTypeDescription"];  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            private void InitClass() {  
                this.columnmbMemberNo = new global::System.Data.DataColumn("mbMemberNo", typeof(int), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columnmbMemberNo);  
                this.columnmbUserName = new global::System.Data.DataColumn("mbUserName", typeof(string), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columnmbUserName);  
                this.columneqEquipmentNo = new global::System.Data.DataColumn("eqEquipmentNo", typeof(int), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columneqEquipmentNo);  
                this.columneqEquipmentLocNo = new global::System.Data.DataColumn("eqEquipmentLocNo", typeof(int), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columneqEquipmentLocNo);  
                this.columneqEquipmentTypeNo = new global::System.Data.DataColumn("eqEquipmentTypeNo", typeof(int), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columneqEquipmentTypeNo);  
                this.columneqEquipmentName = new global::System.Data.DataColumn("eqEquipmentName", typeof(string), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columneqEquipmentName);  
                this.columneqEquipmentMake = new global::System.Data.DataColumn("eqEquipmentMake", typeof(string), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columneqEquipmentMake);  
                this.columneqEquipmentModel = new global::System.Data.DataColumn("eqEquipmentModel", typeof(string), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columneqEquipmentModel);  
                this.columneqEquipmentGymID = new global::System.Data.DataColumn("eqEquipmentGymID", typeof(string), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columneqEquipmentGymID);  
                this.columneqEquipmentNotes = new global::System.Data.DataColumn("eqEquipmentNotes", typeof(string), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columneqEquipmentNotes);  
                this.columneqDateCreated = new global::System.Data.DataColumn("eqDateCreated", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columneqDateCreated);  
                this.columneqDateUpdated = new global::System.Data.DataColumn("eqDateUpdated", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columneqDateUpdated);  
                this.columnloLocation = new global::System.Data.DataColumn("loLocation", typeof(string), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columnloLocation);  
                this.columnloDescription = new global::System.Data.DataColumn("loDescription", typeof(string), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columnloDescription);  
                this.columneqMemberNo = new global::System.Data.DataColumn("eqMemberNo", typeof(int), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columneqMemberNo);  
                this.columntpTypeName = new global::System.Data.DataColumn("tpTypeName", typeof(string), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columntpTypeName);  
                this.columntpTypeDescription = new global::System.Data.DataColumn("tpTypeDescription", typeof(string), null, global::System.Data.MappingType.Element);  
                base.Columns.Add(this.columntpTypeDescription);  
                this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] {  
                                this.columneqEquipmentNo,  
                                this.columneqMemberNo}, true));  
                this.columnmbMemberNo.AllowDBNull = false;  
                this.columnmbUserName.AllowDBNull = false;  
                this.columnmbUserName.MaxLength = 25;  
                this.columneqEquipmentNo.AllowDBNull = false;  
                this.columneqEquipmentLocNo.AllowDBNull = false;  
                this.columneqEquipmentTypeNo.AllowDBNull = false;  
                this.columneqEquipmentName.AllowDBNull = false;  
                this.columneqEquipmentName.MaxLength = 50;  
                this.columneqEquipmentMake.AllowDBNull = false;  
                this.columneqEquipmentMake.MaxLength = 30;  
                this.columneqEquipmentModel.AllowDBNull = false;  
                this.columneqEquipmentModel.MaxLength = 30;  
                this.columneqEquipmentGymID.AllowDBNull = false;  
                this.columneqEquipmentGymID.MaxLength = 15;  
                this.columneqEquipmentNotes.AllowDBNull = false;  
                this.columneqEquipmentNotes.MaxLength = 100;  
                this.columneqDateCreated.AllowDBNull = false;  
                this.columneqDateUpdated.AllowDBNull = false;  
                this.columnloLocation.AllowDBNull = false;  
                this.columnloLocation.MaxLength = 25;  
                this.columnloDescription.AllowDBNull = false;  
                this.columnloDescription.MaxLength = 50;  
                this.columneqMemberNo.AllowDBNull = false;  
                this.columntpTypeName.AllowDBNull = false;  
                this.columntpTypeName.MaxLength = 25;  
                this.columntpTypeDescription.AllowDBNull = false;  
                this.columntpTypeDescription.MaxLength = 300;  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public DataTable1Row NewDataTable1Row() {  
                return ((DataTable1Row)(this.NewRow()));  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {  
                return new DataTable1Row(builder);  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            protected override global::System.Type GetRowType() {  
                return typeof(DataTable1Row);  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {  
                base.OnRowChanged(e);  
                if ((this.DataTable1RowChanged != null)) {  
                    this.DataTable1RowChanged(this, new DataTable1RowChangeEvent(((DataTable1Row)(e.Row)), e.Action));  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {  
                base.OnRowChanging(e);  
                if ((this.DataTable1RowChanging != null)) {  
                    this.DataTable1RowChanging(this, new DataTable1RowChangeEvent(((DataTable1Row)(e.Row)), e.Action));  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {  
                base.OnRowDeleted(e);  
                if ((this.DataTable1RowDeleted != null)) {  
                    this.DataTable1RowDeleted(this, new DataTable1RowChangeEvent(((DataTable1Row)(e.Row)), e.Action));  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {  
                base.OnRowDeleting(e);  
                if ((this.DataTable1RowDeleting != null)) {  
                    this.DataTable1RowDeleting(this, new DataTable1RowChangeEvent(((DataTable1Row)(e.Row)), e.Action));  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public void RemoveDataTable1Row(DataTable1Row 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();  
                iqBodyWorksV02DataSetEquipmentSummary ds = new iqBodyWorksV02DataSetEquipmentSummary();  
                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 = "DataTable1DataTable";  
                type.Attributes.Add(attribute2);  
                type.Particle = sequence;  
                global::System.Xml.Schema.XmlSchema dsdsSchema = 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 iqBodyWorksV02DataSetEquipmentSummaryTableRow : global::System.Data.DataRow {  
              
            private iqBodyWorksV02DataSetEquipmentSummaryTableDataTable tableiqBodyWorksV02DataSetEquipmentSummaryTable;  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            internal iqBodyWorksV02DataSetEquipmentSummaryTableRow(global::System.Data.DataRowBuilder rb) :   
                    base(rb) {  
                this.tableiqBodyWorksV02DataSetEquipmentSummaryTable = ((iqBodyWorksV02DataSetEquipmentSummaryTableDataTable)(this.Table));  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public int eqEquipmentNo {  
                get {  
                    return ((int)(this[this.tableiqBodyWorksV02DataSetEquipmentSummaryTable.eqEquipmentNoColumn]));  
                }  
                set {  
                    this[this.tableiqBodyWorksV02DataSetEquipmentSummaryTable.eqEquipmentNoColumn] = value;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public string eqEquipmentName {  
                get {  
                    return ((string)(this[this.tableiqBodyWorksV02DataSetEquipmentSummaryTable.eqEquipmentNameColumn]));  
                }  
                set {  
                    this[this.tableiqBodyWorksV02DataSetEquipmentSummaryTable.eqEquipmentNameColumn] = value;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public string loLocation {  
                get {  
                    return ((string)(this[this.tableiqBodyWorksV02DataSetEquipmentSummaryTable.loLocationColumn]));  
                }  
                set {  
                    this[this.tableiqBodyWorksV02DataSetEquipmentSummaryTable.loLocationColumn] = value;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public string loDescription {  
                get {  
                    return ((string)(this[this.tableiqBodyWorksV02DataSetEquipmentSummaryTable.loDescriptionColumn]));  
                }  
                set {  
                    this[this.tableiqBodyWorksV02DataSetEquipmentSummaryTable.loDescriptionColumn] = value;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public string mbUserName {  
                get {  
                    return ((string)(this[this.tableiqBodyWorksV02DataSetEquipmentSummaryTable.mbUserNameColumn]));  
                }  
                set {  
                    this[this.tableiqBodyWorksV02DataSetEquipmentSummaryTable.mbUserNameColumn] = value;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public string tpTypeName {  
                get {  
                    return ((string)(this[this.tableiqBodyWorksV02DataSetEquipmentSummaryTable.tpTypeNameColumn]));  
                }  
                set {  
                    this[this.tableiqBodyWorksV02DataSetEquipmentSummaryTable.tpTypeNameColumn] = value;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public string tpTypeDescription {  
                get {  
                    return ((string)(this[this.tableiqBodyWorksV02DataSetEquipmentSummaryTable.tpTypeDescriptionColumn]));  
                }  
                set {  
                    this[this.tableiqBodyWorksV02DataSetEquipmentSummaryTable.tpTypeDescriptionColumn] = value;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public int eqEquipmentTypeNo {  
                get {  
                    return ((int)(this[this.tableiqBodyWorksV02DataSetEquipmentSummaryTable.eqEquipmentTypeNoColumn]));  
                }  
                set {  
                    this[this.tableiqBodyWorksV02DataSetEquipmentSummaryTable.eqEquipmentTypeNoColumn] = value;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public string tpTypeCode {  
                get {  
                    return ((string)(this[this.tableiqBodyWorksV02DataSetEquipmentSummaryTable.tpTypeCodeColumn]));  
                }  
                set {  
                    this[this.tableiqBodyWorksV02DataSetEquipmentSummaryTable.tpTypeCodeColumn] = value;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public int eqMemberNo {  
                get {  
                    return ((int)(this[this.tableiqBodyWorksV02DataSetEquipmentSummaryTable.eqMemberNoColumn]));  
                }  
                set {  
                    this[this.tableiqBodyWorksV02DataSetEquipmentSummaryTable.eqMemberNoColumn] = value;  
                }  
            }  
        }  
          
        /// <summary> 
        ///Represents strongly named DataRow class.  
        ///</summary> 
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]  
        public partial class DataTable1Row : global::System.Data.DataRow {  
              
            private DataTable1DataTable tableDataTable1;  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            internal DataTable1Row(global::System.Data.DataRowBuilder rb) :   
                    base(rb) {  
                this.tableDataTable1 = ((DataTable1DataTable)(this.Table));  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public int mbMemberNo {  
                get {  
                    return ((int)(this[this.tableDataTable1.mbMemberNoColumn]));  
                }  
                set {  
                    this[this.tableDataTable1.mbMemberNoColumn] = value;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public string mbUserName {  
                get {  
                    return ((string)(this[this.tableDataTable1.mbUserNameColumn]));  
                }  
                set {  
                    this[this.tableDataTable1.mbUserNameColumn] = value;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public int eqEquipmentNo {  
                get {  
                    return ((int)(this[this.tableDataTable1.eqEquipmentNoColumn]));  
                }  
                set {  
                    this[this.tableDataTable1.eqEquipmentNoColumn] = value;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public int eqEquipmentLocNo {  
                get {  
                    return ((int)(this[this.tableDataTable1.eqEquipmentLocNoColumn]));  
                }  
                set {  
                    this[this.tableDataTable1.eqEquipmentLocNoColumn] = value;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public int eqEquipmentTypeNo {  
                get {  
                    return ((int)(this[this.tableDataTable1.eqEquipmentTypeNoColumn]));  
                }  
                set {  
                    this[this.tableDataTable1.eqEquipmentTypeNoColumn] = value;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public string eqEquipmentName {  
                get {  
                    return ((string)(this[this.tableDataTable1.eqEquipmentNameColumn]));  
                }  
                set {  
                    this[this.tableDataTable1.eqEquipmentNameColumn] = value;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public string eqEquipmentMake {  
                get {  
                    return ((string)(this[this.tableDataTable1.eqEquipmentMakeColumn]));  
                }  
                set {  
                    this[this.tableDataTable1.eqEquipmentMakeColumn] = value;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public string eqEquipmentModel {  
                get {  
                    return ((string)(this[this.tableDataTable1.eqEquipmentModelColumn]));  
                }  
                set {  
                    this[this.tableDataTable1.eqEquipmentModelColumn] = value;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public string eqEquipmentGymID {  
                get {  
                    return ((string)(this[this.tableDataTable1.eqEquipmentGymIDColumn]));  
                }  
                set {  
                    this[this.tableDataTable1.eqEquipmentGymIDColumn] = value;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public string eqEquipmentNotes {  
                get {  
                    return ((string)(this[this.tableDataTable1.eqEquipmentNotesColumn]));  
                }  
                set {  
                    this[this.tableDataTable1.eqEquipmentNotesColumn] = value;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public System.DateTime eqDateCreated {  
                get {  
                    return ((global::System.DateTime)(this[this.tableDataTable1.eqDateCreatedColumn]));  
                }  
                set {  
                    this[this.tableDataTable1.eqDateCreatedColumn] = value;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public System.DateTime eqDateUpdated {  
                get {  
                    return ((global::System.DateTime)(this[this.tableDataTable1.eqDateUpdatedColumn]));  
                }  
                set {  
                    this[this.tableDataTable1.eqDateUpdatedColumn] = value;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public string loLocation {  
                get {  
                    return ((string)(this[this.tableDataTable1.loLocationColumn]));  
                }  
                set {  
                    this[this.tableDataTable1.loLocationColumn] = value;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public string loDescription {  
                get {  
                    return ((string)(this[this.tableDataTable1.loDescriptionColumn]));  
                }  
                set {  
                    this[this.tableDataTable1.loDescriptionColumn] = value;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public int eqMemberNo {  
                get {  
                    return ((int)(this[this.tableDataTable1.eqMemberNoColumn]));  
                }  
                set {  
                    this[this.tableDataTable1.eqMemberNoColumn] = value;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public string tpTypeName {  
                get {  
                    return ((string)(this[this.tableDataTable1.tpTypeNameColumn]));  
                }  
                set {  
                    this[this.tableDataTable1.tpTypeNameColumn] = value;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public string tpTypeDescription {  
                get {  
                    return ((string)(this[this.tableDataTable1.tpTypeDescriptionColumn]));  
                }  
                set {  
                    this[this.tableDataTable1.tpTypeDescriptionColumn] = value;  
                }  
            }  
        }  
          
        /// <summary> 
        ///Row event argument class  
        ///</summary> 
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]  
        public class iqBodyWorksV02DataSetEquipmentSummaryTableRowChangeEvent : global::System.EventArgs {  
              
            private iqBodyWorksV02DataSetEquipmentSummaryTableRow eventRow;  
              
            private global::System.Data.DataRowAction eventAction;  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public iqBodyWorksV02DataSetEquipmentSummaryTableRowChangeEvent(iqBodyWorksV02DataSetEquipmentSummaryTableRow row, global::System.Data.DataRowAction action) {  
                this.eventRow = row;  
                this.eventAction = action;  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public iqBodyWorksV02DataSetEquipmentSummaryTableRow Row {  
                get {  
                    return this.eventRow;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataRowAction Action {  
                get {  
                    return this.eventAction;  
                }  
            }  
        }  
          
        /// <summary> 
        ///Row event argument class  
        ///</summary> 
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]  
        public class DataTable1RowChangeEvent : global::System.EventArgs {  
              
            private DataTable1Row eventRow;  
              
            private global::System.Data.DataRowAction eventAction;  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public DataTable1RowChangeEvent(DataTable1Row row, global::System.Data.DataRowAction action) {  
                this.eventRow = row;  
                this.eventAction = action;  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public DataTable1Row Row {  
                get {  
                    return this.eventRow;  
                }  
            }  
              
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
            public global::System.Data.DataRowAction Action {  
                get {  
                    return this.eventAction;  
                }  
            }  
        }  
    }  
}  
namespace iqReports_lib.iqBodyWorksV02DataSetEquipmentSummaryTableAdapters {  
      
      
    /// <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=neutralPublicKeyToken=b03f5f7f11d50a3a")]  
    [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]  
    public partial class iqBodyWorksV02DataSetEquipmentSummaryTableAdapter : 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 iqBodyWorksV02DataSetEquipmentSummaryTableAdapter() {  
            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 = "iqBodyWorksV02DataSetEquipmentSummaryTable";  
            tableMapping.ColumnMappings.Add("eqEquipmentNo", "eqEquipmentNo");  
            tableMapping.ColumnMappings.Add("eqEquipmentName", "eqEquipmentName");  
            tableMapping.ColumnMappings.Add("loLocation", "loLocation");  
            tableMapping.ColumnMappings.Add("loDescription", "loDescription");  
            tableMapping.ColumnMappings.Add("mbUserName", "mbUserName");  
            tableMapping.ColumnMappings.Add("tpTypeName", "tpTypeName");  
            tableMapping.ColumnMappings.Add("tpTypeDescription", "tpTypeDescription");  
            tableMapping.ColumnMappings.Add("eqEquipmentTypeNo", "eqEquipmentTypeNo");  
            tableMapping.ColumnMappings.Add("tpTypeCode", "tpTypeCode");  
            tableMapping.ColumnMappings.Add("eqMemberNo", "eqMemberNo");  
            this._adapter.TableMappings.Add(tableMapping);  
        }  
          
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
        private void InitConnection() {  
            this._connection = new global::System.Data.SqlClient.SqlConnection();  
            this._connection.ConnectionString = global::iqReports_lib.Properties.Settings.Default.iqBodyWorksV02LapTopReportDataConnection;  
        }  
          
        [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     Equipment.eqEquipmentNo, Equipment.eqEquipmentName, Locations.loLocation, Locations.loDescription, Members.mbUserName,   
                      Types.tpTypeName, Types.tpTypeDescription, Equipment.eqEquipmentTypeNo, Types.tpTypeCode, Equipment.eqMemberNo  
FROM         Equipment INNER JOIN  
                      Locations ON Equipment.eqMemberNo = Locations.loMemberNo AND Equipment.eqEquipmentLocNo = Locations.loNumber INNER JOIN  
                      Types ON Equipment.eqEquipmentTypeNo = Types.tpMemberNo AND Equipment.eqEquipmentTypeNo = Types.tpTypeNo INNER JOIN  
                      Members ON Equipment.eqMemberNo = Members.mbMemberNo   
WHERE mbMemberNo=@MemberParm  
";  
            this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;  
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@MemberParm", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 0, 0, "mbMemberNo", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));  
        }  
          
        [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(iqBodyWorksV02DataSetEquipmentSummary.iqBodyWorksV02DataSetEquipmentSummaryTableDataTable dataTable, int MemberParm) {  
            thisthis.Adapter.SelectCommand = this.CommandCollection[0];  
            this.Adapter.SelectCommand.Parameters[0].Value = ((int)(MemberParm));  
            if ((this.ClearBeforeFill == true)) {  
                dataTable.Clear();  
            }  
            int returnValue = this.Adapter.Fill(dataTable);  
            return returnValue;  
        }  
       // iqworks  
        [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(iqBodyWorksV02DataSetEquipmentSummary.iqBodyWorksV02DataSetEquipmentSummaryTableDataTable dataTable, int MemberParm)  
        public virtual int Fill(iqBodyWorksV02DataSetEquipmentSummary.iqBodyWorksV02DataSetEquipmentSummaryTableDataTable dataTable)  
       {  
          //  thisthis.Adapter.SelectCommand = this.CommandCollection[0];  
          //  this.Adapter.SelectCommand.Parameters[0].Value = ((int)(MemberParm));  
            if ((this.ClearBeforeFill == true))  
            {  
                dataTable.Clear();  
            }  
            int returnValue = this.Adapter.Fill(dataTable);  
            return returnValue;  
        }  
       // iqworks  
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]  
        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)]  
        public virtual iqBodyWorksV02DataSetEquipmentSummary.iqBodyWorksV02DataSetEquipmentSummaryTableDataTable GetData(int MemberParm) {  
            thisthis.Adapter.SelectCommand = this.CommandCollection[0];  
            this.Adapter.SelectCommand.Parameters[0].Value = ((int)(MemberParm));  
            iqBodyWorksV02DataSetEquipmentSummary.iqBodyWorksV02DataSetEquipmentSummaryTableDataTable dataTable = new iqBodyWorksV02DataSetEquipmentSummary.iqBodyWorksV02DataSetEquipmentSummaryTableDataTable();  
            this.Adapter.Fill(dataTable);  
            return dataTable;  
        }  
    }  
      
    /// <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=neutralPublicKeyToken=b03f5f7f11d50a3a")]  
    [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]  
    public partial class DataTable1TableAdapter : 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 DataTable1TableAdapter() {  
            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 = "DataTable1";  
            tableMapping.ColumnMappings.Add("mbMemberNo", "mbMemberNo");  
            tableMapping.ColumnMappings.Add("mbUserName", "mbUserName");  
            tableMapping.ColumnMappings.Add("eqEquipmentNo", "eqEquipmentNo");  
            tableMapping.ColumnMappings.Add("eqEquipmentLocNo", "eqEquipmentLocNo");  
            tableMapping.ColumnMappings.Add("eqEquipmentTypeNo", "eqEquipmentTypeNo");  
            tableMapping.ColumnMappings.Add("eqEquipmentName", "eqEquipmentName");  
            tableMapping.ColumnMappings.Add("eqEquipmentMake", "eqEquipmentMake");  
            tableMapping.ColumnMappings.Add("eqEquipmentModel", "eqEquipmentModel");  
            tableMapping.ColumnMappings.Add("eqEquipmentGymID", "eqEquipmentGymID");  
            tableMapping.ColumnMappings.Add("eqEquipmentNotes", "eqEquipmentNotes");  
            tableMapping.ColumnMappings.Add("eqDateCreated", "eqDateCreated");  
            tableMapping.ColumnMappings.Add("eqDateUpdated", "eqDateUpdated");  
            tableMapping.ColumnMappings.Add("loLocation", "loLocation");  
            tableMapping.ColumnMappings.Add("loDescription", "loDescription");  
            tableMapping.ColumnMappings.Add("eqMemberNo", "eqMemberNo");  
            tableMapping.ColumnMappings.Add("tpTypeName", "tpTypeName");  
            tableMapping.ColumnMappings.Add("tpTypeDescription", "tpTypeDescription");  
            this._adapter.TableMappings.Add(tableMapping);  
        }  
          
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
        private void InitConnection() {  
            this._connection = new global::System.Data.SqlClient.SqlConnection();  
            this._connection.ConnectionString = global::iqReports_lib.Properties.Settings.Default.iqBodyWorksV02LapTopReportDataConnection;  
        }  
          
        [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     Members.mbMemberNo, Members.mbUserName, Equipment.eqEquipmentNo, Equipment.eqEquipmentLocNo, Equipment.eqEquipmentTypeNo,   
                      Equipment.eqEquipmentName, Equipment.eqEquipmentMake, Equipment.eqEquipmentModel, Equipment.eqEquipmentGymID,   
                      Equipment.eqEquipmentNotes, Equipment.eqDateCreated, Equipment.eqDateUpdated, Locations.loLocation, Locations.loDescription,   
                      Equipment.eqMemberNo, Types.tpTypeName, Types.tpTypeDescription  
FROM         Members INNER JOIN  
                      Equipment ON Members.mbMemberNo = Equipment.eqMemberNo INNER JOIN  
                      Locations ON Equipment.eqMemberNo = Locations.loMemberNo AND Equipment.eqEquipmentLocNo = Locations.loNumber INNER JOIN  
                      Types ON Equipment.eqMemberNo = Types.tpMemberNo AND Equipment.eqEquipmentTypeNo = Types.tpTypeNo  
WHERE     (Members.mbMemberNo = @MemberNo)";  
            this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;  
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@MemberNo", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 0, 0, "mbMemberNo", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));  
        }  
          
        [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 iqFill(iqBodyWorksV02DataSetEquipmentSummary.DataTable1DataTable dataTable, int MemberNo) {  
            thisthis.Adapter.SelectCommand = this.CommandCollection[0];  
            this.Adapter.SelectCommand.Parameters[0].Value = ((int)(MemberNo));  
            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 iqBodyWorksV02DataSetEquipmentSummary.DataTable1DataTable iqGetData(int MemberNo) {  
            thisthis.Adapter.SelectCommand = this.CommandCollection[0];  
            this.Adapter.SelectCommand.Parameters[0].Value = ((int)(MemberNo));  
            iqBodyWorksV02DataSetEquipmentSummary.DataTable1DataTable dataTable = new iqBodyWorksV02DataSetEquipmentSummary.DataTable1DataTable();  
            this.Adapter.Fill(dataTable);  
            return dataTable;  
        }  
    }  
      
    /// <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=neutralPublicKeyToken=b03f5f7f11d50a3a")]  
    [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]  
    public partial class quick_equipment_name : global::System.ComponentModel.Component {  
          
        private global::System.Data.IDbCommand[] _commandCollection;  
          
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
        protected global::System.Data.IDbCommand[] CommandCollection {  
            get {  
                if ((this._commandCollection == null)) {  
                    this.InitCommandCollection();  
                }  
                return this._commandCollection;  
            }  
        }  
          
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
        private void InitCommandCollection() {  
            this._commandCollection = new global::System.Data.IDbCommand[1];  
            this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();  
            ((global::System.Data.SqlClient.SqlCommand)(this._commandCollection[0])).Connection = new global::System.Data.SqlClient.SqlConnection(global::iqReports_lib.Properties.Settings.Default.iqBodyWorksV02LapTopReportDataConnection);  
            ((global::System.Data.SqlClient.SqlCommand)(this._commandCollection[0])).CommandText = @"SELECT     Members.mbMemberNo, Members.mbUserName, Equipment.eqEquipmentNo, Equipment.eqEquipmentLocNo, Equipment.eqEquipmentTypeNo,   
                      Equipment.eqEquipmentName, Equipment.eqEquipmentMake, Equipment.eqEquipmentModel, Equipment.eqEquipmentGymID,   
                      Equipment.eqEquipmentNotes, Equipment.eqDateCreated, Equipment.eqDateUpdated, Locations.loLocation, Locations.loDescription,   
                      Equipment.eqMemberNo, Types.tpTypeName, Types.tpTypeDescription  
FROM         Members INNER JOIN  
                      Equipment ON Members.mbMemberNo = Equipment.eqMemberNo INNER JOIN  
                      Locations ON Equipment.eqMemberNo = Locations.loMemberNo AND Equipment.eqEquipmentLocNo = Locations.loNumber INNER JOIN  
                      Types ON Equipment.eqMemberNo = Types.tpMemberNo AND Equipment.eqEquipmentTypeNo = Types.tpTypeNo  
WHERE     (Members.mbMemberNo = @MemberNo)";  
            ((global::System.Data.SqlClient.SqlCommand)(this._commandCollection[0])).CommandType = global::System.Data.CommandType.Text;  
            ((global::System.Data.SqlClient.SqlCommand)(this._commandCollection[0])).Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@MemberNo", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 0, 0, "mbMemberNo", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));  
        }  
          
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]  
        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]  
        public virtual global::System.Nullable<int> Equipment_FullInfo(int MemberNo) {  
            global::System.Data.SqlClient.SqlCommand command = ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[0]));  
            command.Parameters[0].Value = ((int)(MemberNo));  
            global::System.Data.ConnectionState previousConnectionState = command.Connection.State;  
            if (((command.Connection.State & global::System.Data.ConnectionState.Open)   
                        != global::System.Data.ConnectionState.Open)) {  
                command.Connection.Open();  
            }  
            object returnValue;  
            try {  
                returnValue = command.ExecuteScalar();  
            }  
            finally {  
                if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {  
                    command.Connection.Close();  
                }  
            }  
            if (((returnValue == null)   
                        || (returnValue.GetType() == typeof(global::System.DBNull)))) {  
                return new global::System.Nullable<int>();  
            }  
            else {  
                return new global::System.Nullable<int>(((int)(returnValue)));  
            }  
        }  
    }  
}  
 
#pragma warning restore 1591 

I guess something is not where it is suppose to be. In other words, there is something I didnt do.

I have this last part already posted out there, but just as an aside for this post .....
As another clue that I must be doing something wrong is because when I add a parm. I get a message about missing a Fill method with 1 parameter. It seems like adding the parm caused the wizard to take the existing Fill method with 1 parm, and just added a parm to that, instead of creating a copy of the 1 parm fill method and adding the new parm this copy of the Fill methoid. 

thanks for any help.  

1 Answer, 1 is accepted

Sort by
0
IQworks
Top achievements
Rank 1
answered on 13 Sep 2009, 07:42 PM
Hi again,
   It seems like I have things working - BUT - I am sure I am not doing somethings correctly because i am having to go into the code to make this work the way I need. 
   In the meantime, I have seen some documentation, but if you could give me links to the best places to see videos or anything else that could help me understand telerik reporting a little more, it would be much appreciated 

   Right now to pass parameters to my report from a regular aspx page, I have gone into my report.cs and added another method signiture that takes the parm. This is the method I call from my aspx page. Then from this method in my report.cs, I call the appropriate signiture from the XSD class and it works. I read somewhere there are 3 ways to pass parms to get this process going. 

  The other things is that when I have the report.cs in design mode, I had to go into its code to the method it does a try/catch with that uses the signiture with my parm. There, I hard code the parm I want to use. I am having trouble understanding how to connect the dots so that I can use the report collection editor to run the parm with different values. 

   anyway, thanks for your product, and the help you have given me in the past !!

  
Tags
General Discussions
Asked by
IQworks
Top achievements
Rank 1
Answers by
IQworks
Top achievements
Rank 1
Share this question
or