I've got this snippet from an XSD file in my application...
---------------------------
<TableAdapter BaseClass="Syst em.ComponentMod el.Component"
DataAccessorMod ifier="AutoLayo ut, AnsiClass, Class, Public"
DataAccessorNam e="usp_Billing_ Report_by_MainT ableAdapter"
GeneratorDataCo mponentClassNam e="usp_Billing_ Report_by_MainT ableAdapter"
Name="usp_Billi ng_Report_by_Ma in"
UserDataCompone ntName="usp_Bil ling_Report_by_ MainTableAdapte r">
<MainSource>
<DbSource ConnectionRef=" NewReportingCon nectionString (Web.config)"
DbObjectName="N ewReporting.dbo .usp_Billing_Re port_by_Main"
DbObjectType="S toredProcedure" FillMethodModif ier="Public"
FillMethodName= "FillMonthlyBil lingReport" GenerateMethods ="Both"
GenerateShortCo mmands="false"
GeneratorGetMet hodName="GetMon thlyBillingRepo rt"
GeneratorSource Name="FillMonth lyBillingReport "
GetMethodModifi er="Public" GetMethodName=" GetMonthlyBilli ngReport"
QueryType="Rows et" ScalarCallRetva l="System.Objec t, mscorlib,
Version=2.0.0.0 , Culture=neutral , PublicKeyToken= b77a5c561934e08 9"
UseOptimisticCo ncurrency="fals e"
UserGetMethodNa me="GetMonthlyB illingReport"
UserSourceName= "FillMonthlyBil lingReport">
<SelectComman d>
<DbCommand CommandType="St oredProcedure" ModifiedByUser= "false">
<CommandText>db o.usp_Billing_R eport_by_Main</CommandText>
<Parameters>
<Parameter AllowDbNull="tr ue" AutogeneratedNa me=""
DataSourceName= "" DbType="Int32" Direction="Retu rnValue"
ParameterName=" @RETURN_VALUE" Precision="10" ProviderType="I nt"
Scale="0" Size="4" SourceColumnNul lMapping="false "
SourceVersion=" Current" />
<Parameter AllowDbNull="tr ue" AutogeneratedNa me=""
DataSourceName= "" DbType="AnsiStr ing" Direction="Inpu t"
ParameterName=" @StartDate" Precision="0" ProviderType="V arChar"
Scale="0" Size="10" SourceColumnNul lMapping="false "
SourceVersion=" Current" />
<Parameter AllowDbNull="tr ue" AutogeneratedNa me=""
DataSourceName= "" DbType="AnsiStr ing" Direction="Inpu t"
ParameterName=" @EndDate" Precision="0" ProviderType="V arChar" Scale="0"
Size="10" SourceColumnNul lMapping="false " SourceVersion=" Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="M ainAcctNum" DataSetColumn=" MainAcctNum" />
<Mapping SourceColumn="M ainAcctName" DataSetColumn=" MainAcctName" />
<Mapping SourceColumn="A utoAttnTime" DataSetColumn=" AutoAttnTime" />
<Mapping SourceColumn="O peratorTime" DataSetColumn=" OperatorTime" />
<Mapping SourceColumn="P atchTime" DataSetColumn=" PatchTime" />
<Mapping SourceColumn="N umCalls" DataSetColumn=" NumCalls" />
</Mappings>
<Sources />
</TableAdapter>
--------------------------
I'm looking for information on all the possible tags or properties that
can be used with the <DBCommandtag . Where is this information? I'm
Googling it but not being very successful.
Thanks,
Andrew
---------------------------
<TableAdapter BaseClass="Syst em.ComponentMod el.Component"
DataAccessorMod ifier="AutoLayo ut, AnsiClass, Class, Public"
DataAccessorNam e="usp_Billing_ Report_by_MainT ableAdapter"
GeneratorDataCo mponentClassNam e="usp_Billing_ Report_by_MainT ableAdapter"
Name="usp_Billi ng_Report_by_Ma in"
UserDataCompone ntName="usp_Bil ling_Report_by_ MainTableAdapte r">
<MainSource>
<DbSource ConnectionRef=" NewReportingCon nectionString (Web.config)"
DbObjectName="N ewReporting.dbo .usp_Billing_Re port_by_Main"
DbObjectType="S toredProcedure" FillMethodModif ier="Public"
FillMethodName= "FillMonthlyBil lingReport" GenerateMethods ="Both"
GenerateShortCo mmands="false"
GeneratorGetMet hodName="GetMon thlyBillingRepo rt"
GeneratorSource Name="FillMonth lyBillingReport "
GetMethodModifi er="Public" GetMethodName=" GetMonthlyBilli ngReport"
QueryType="Rows et" ScalarCallRetva l="System.Objec t, mscorlib,
Version=2.0.0.0 , Culture=neutral , PublicKeyToken= b77a5c561934e08 9"
UseOptimisticCo ncurrency="fals e"
UserGetMethodNa me="GetMonthlyB illingReport"
UserSourceName= "FillMonthlyBil lingReport">
<SelectComman d>
<DbCommand CommandType="St oredProcedure" ModifiedByUser= "false">
<CommandText>db o.usp_Billing_R eport_by_Main</CommandText>
<Parameters>
<Parameter AllowDbNull="tr ue" AutogeneratedNa me=""
DataSourceName= "" DbType="Int32" Direction="Retu rnValue"
ParameterName=" @RETURN_VALUE" Precision="10" ProviderType="I nt"
Scale="0" Size="4" SourceColumnNul lMapping="false "
SourceVersion=" Current" />
<Parameter AllowDbNull="tr ue" AutogeneratedNa me=""
DataSourceName= "" DbType="AnsiStr ing" Direction="Inpu t"
ParameterName=" @StartDate" Precision="0" ProviderType="V arChar"
Scale="0" Size="10" SourceColumnNul lMapping="false "
SourceVersion=" Current" />
<Parameter AllowDbNull="tr ue" AutogeneratedNa me=""
DataSourceName= "" DbType="AnsiStr ing" Direction="Inpu t"
ParameterName=" @EndDate" Precision="0" ProviderType="V arChar" Scale="0"
Size="10" SourceColumnNul lMapping="false " SourceVersion=" Current" />
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="M ainAcctNum" DataSetColumn=" MainAcctNum" />
<Mapping SourceColumn="M ainAcctName" DataSetColumn=" MainAcctName" />
<Mapping SourceColumn="A utoAttnTime" DataSetColumn=" AutoAttnTime" />
<Mapping SourceColumn="O peratorTime" DataSetColumn=" OperatorTime" />
<Mapping SourceColumn="P atchTime" DataSetColumn=" PatchTime" />
<Mapping SourceColumn="N umCalls" DataSetColumn=" NumCalls" />
</Mappings>
<Sources />
</TableAdapter>
--------------------------
I'm looking for information on all the possible tags or properties that
can be used with the <DBCommandtag . Where is this information? I'm
Googling it but not being very successful.
Thanks,
Andrew