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 ...
Here is my iqEquipment_Summary.cs Report
Here is my XSD designer.cs
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.
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=neutral, PublicKeyToken=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=neutral, PublicKeyToken=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=neutral, PublicKeyToken=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.