Home All Groups Group Topic Archive Search About

RE: detailsview,

microsoft.public.dotnet.framework.aspnet.webcontrols
Author
20 Jan 2006 6:27 PM
TdarTdar
Excelent that works, I assume that this will be put on the bug
list to get fixed.

thanks for your help

Tdar

Show quoteHide quote
"Steven Cheng[MSFT]" wrote:

> Hi Tdar,
>
> I've performed some further tests through the test data you provided, and I
> did encounter some problem when using the autogenerated TypeDataSet/
> TableAdapter (and bind to objectdatasource and DetailsView...).  Actually,
> the test table you provide doesn't specify a primary key column ( i
> manually set the "ShipKey" as the pk...) , then creating the the
> TableAdapter/DataSet from that table, and the  when using the
> ObjectDataSource with the TableAdapter, it will set the DataObjectTypeName
> to "System.Guid", this is not correct, we can remove that attribute , or
> make it empty......
>
> Then, when bind the objectdatasource to DetailsView control, it  will make
> the "ShipKey" field as readonly bydefault (as it is primary key), e.g:
>
> <asp:BoundField DataField="ShipKey" HeaderText="ShipKey" 
> SortExpression="ShipKey"  ReadOnly="true" />
>
> this will make the ShipKey value not passed when performing update
> operation. we can just remove the ReadOnly attribute or set it to false ,
> thus when updating item, the ShipKey value will also be passed...., so my
> current  test DataSet code and page code is like:
>
> =========dataset============
> <?xml version="1.0" encoding="utf-8"?>
> <xs:schema id="OrderShipDS"
> targetNamespace="http://tempuri.org/OrderShipDS.xsd"
> xmlns:mstns="http://tempuri.org/OrderShipDS.xsd"
> xmlns="http://tempuri.org/OrderShipDS.xsd"
> xmlns:xs="http://www.w3.org/2001/XMLSchema"
> xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
> xmlns:msprop="urn:schemas-microsoft-com:xml-msprop"
> attributeFormDefault="qualified" elementFormDefault="qualified">
>   <xs:annotation>
>     <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
>       <DataSource DefaultConnectionIndex="0"
> FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout,
> AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema"
> xmlns="urn:schemas-microsoft-com:xml-msdatasource">
>         <Connections>
>           <Connection AppSettingsObjectName="Web.config"
> AppSettingsPropertyName="testdbConnectionString" ConnectionStringObject=""
> IsAppSettingsProperty="True" Modifier="Assembly"
> Name="testdbConnectionString (Web.config)" ParameterPrefix="@"
> PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.Con
> nectionStrings.testdbConnectionString.ConnectionString"
> Provider="System.Data.SqlClient">
>           </Connection>
>         </Connections>
>         <Tables>
>           <TableAdapter BaseClass="System.ComponentModel.Component"
> DataAccessorModifier="AutoLayout, AnsiClass, Class, Public"
> DataAccessorName="OrderShipRecordTableAdapter"
> GeneratorDataComponentClassName="OrderShipRecordTableAdapter"
> Name="OrderShipRecord" UserDataComponentName="OrderShipRecordTableAdapter">
>             <MainSource>
>               <DbSource ConnectionRef="testdbConnectionString (Web.config)"
> DbObjectName="testdb.dbo.OrderShipRecord" DbObjectType="Table"
> FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both"
> GenerateShortCommands="True" GeneratorGetMethodName="GetData"
> GeneratorSourceName="Fill" GetMethodModifier="Public"
> GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object,
> mscorlib, Version=2.0.0.0, Culture=neutral,
> PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False"
> UserGetMethodName="GetData" UserSourceName="Fill">
>                 <DeleteCommand>
>                   <DbCommand CommandType="Text" ModifiedByUser="False">
>                     <CommandText>DELETE FROM [OrderShipRecord] WHERE
> (([ShipKey] = @Original_ShipKey))</CommandText>
>                     <Parameters>
>                       <Parameter AllowDbNull="False" AutogeneratedName=""
> DataSourceName="" DbType="Guid" Direction="Input"
> ParameterName="@Original_ShipKey" Precision="0"
> ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ShipKey"
> SourceColumnNullMapping="False" SourceVersion="Original">
>                       </Parameter>
>                     </Parameters>
>                   </DbCommand>
>                 </DeleteCommand>
>                 <InsertCommand>
>                   <DbCommand CommandType="Text" ModifiedByUser="False">
>                     <CommandText>INSERT INTO [OrderShipRecord] ([ShipKey],
> [DBMANTransNumber], [CreatedDate], [PackagedDate], [UserId], [CarrierCode],
> [LocationCode], [ShippingServiceID], [ShipInsuranceID], [OrderTypeRWC],
> [SignatureReq], [HighValueFlag], [ShipCost], [OrderTotal],
> [ChinaSurcharges], [CrystalSurcharges], [OtherSurcharges],
> [Order_StaffKeyID], [Paid], [ShiptoCompany], [ShiptoName], [ShipToAddress],
> [ShipToAddress2], [ShipCity], [ShipCountry], [ShipState], [ZipCode],
> [SignRqByPassReport], [Final_CarrierCode], [Final_ShippingServiceID],
> [Final_NumPkgs], [Final_ShipCost], [Final_DeclaredValue],
> [Final_CODAmount], [Final_Zone], [Final_FreightCharge], [Final_Weight],
> [Final_ShipDate], [UPS_ShipCost], [UPS_Signature], [UPS_Delivered],
> [UPS_DeliveredDate], [Org_Company], [Org_Name], [Org_Address], [Org_City],
> [Org_State], [Org_Zip], [ORG_DbmanShipmtd], [ORG_dbmanShipMNW],
> [ORG_DBMANsalesCode], [ORG_2ndODRTot], [org_shiptran1], [org_airbill1],
> [Org_Airbill2], [Org_SplitODRStus], [ORG_PakDate], [ORG_PakDate2],
> [DBMAN_STATUS], [DBMANSURCHARGES], [EMAIL], [Breakable],
> [DBMAN_OrderTotal], [ORG_DEPARTMENT], [ORG_PREMIUMBR], [CODE], [APPRSCDE])
> VALUES (@ShipKey, @DBMANTransNumber, @CreatedDate, @PackagedDate, @UserId,
> @CarrierCode, @LocationCode, @ShippingServiceID, @ShipInsuranceID,
> @OrderTypeRWC, @SignatureReq, @HighValueFlag, @ShipCost, @OrderTotal,
> @ChinaSurcharges, @CrystalSurcharges, @OtherSurcharges, @Order_StaffKeyID,
> @Paid, @ShiptoCompany, @ShiptoName, @ShipToAddress, @ShipToAddress2,
> @ShipCity, @ShipCountry, @ShipState, @ZipCode, @SignRqByPassReport,
> @Final_CarrierCode, @Final_ShippingServiceID, @Final_NumPkgs,
> @Final_ShipCost, @Final_DeclaredValue, @Final_CODAmount, @Final_Zone,
> @Final_FreightCharge, @Final_Weight, @Final_ShipDate, @UPS_ShipCost,
> @UPS_Signature, @UPS_Delivered, @UPS_DeliveredDate, @Org_Company,
> @Org_Name, @Org_Address, @Org_City, @Org_State, @Org_Zip,
> @ORG_DbmanShipmtd, @ORG_dbmanShipMNW, @ORG_DBMANsalesCode, @ORG_2ndODRTot,
> @org_shiptran1, @org_airbill1, @Org_Airbill2, @Org_SplitODRStus,
> @ORG_PakDate, @ORG_PakDate2, @DBMAN_STATUS, @DBMANSURCHARGES, @EMAIL,
> @Breakable, @DBMAN_OrderTotal, @ORG_DEPARTMENT, @ORG_PREMIUMBR, @CODE,
> @APPRSCDE)</CommandText>
>                     <Parameters>
>                       <Parameter AllowDbNull="False" AutogeneratedName=""
> DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ShipKey"
> Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0"
> SourceColumn="ShipKey" SourceColumnNullMapping="False"
> SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="False" AutogeneratedName=""
> DataSourceName="" DbType="String" Direction="Input"
> ParameterName="@DBMANTransNumber" Precision="0" ProviderType="NVarChar"
> Scale="0" Size="0" SourceColumn="DBMANTransNumber"
> SourceColumnNullMapping="False" SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="False" AutogeneratedName=""
> DataSourceName="" DbType="DateTime" Direction="Input"
> ParameterName="@CreatedDate" Precision="0" ProviderType="DateTime"
> Scale="0" Size="0" SourceColumn="CreatedDate"
> SourceColumnNullMapping="False" SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="DateTime" Direction="Input"
> ParameterName="@PackagedDate" Precision="0" ProviderType="DateTime"
> Scale="0" Size="0" SourceColumn="PackagedDate"
> SourceColumnNullMapping="False" SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="False" AutogeneratedName=""
> DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@UserId"
> Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0"
> SourceColumn="UserId" SourceColumnNullMapping="False"
> SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input"
> ParameterName="@CarrierCode" Precision="0" ProviderType="Char" Scale="0"
> Size="0" SourceColumn="CarrierCode" SourceColumnNullMapping="False"
> SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input"
> ParameterName="@LocationCode" Precision="0" ProviderType="Char" Scale="0"
> Size="0" SourceColumn="LocationCode" SourceColumnNullMapping="False"
> SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input"
> ParameterName="@ShippingServiceID" Precision="0" ProviderType="Char"
> Scale="0" Size="0" SourceColumn="ShippingServiceID"
> SourceColumnNullMapping="False" SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input"
> ParameterName="@ShipInsuranceID" Precision="0" ProviderType="Char"
> Scale="0" Size="0" SourceColumn="ShipInsuranceID"
> SourceColumnNullMapping="False" SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input"
> ParameterName="@OrderTypeRWC" Precision="0" ProviderType="Char" Scale="0"
> Size="0" SourceColumn="OrderTypeRWC" SourceColumnNullMapping="False"
> SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="Boolean" Direction="Input"
> ParameterName="@SignatureReq" Precision="0" ProviderType="Bit" Scale="0"
> Size="0" SourceColumn="SignatureReq" SourceColumnNullMapping="False"
> SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="Boolean" Direction="Input"
> ParameterName="@HighValueFlag" Precision="0" ProviderType="Bit" Scale="0"
> Size="0" SourceColumn="HighValueFlag" SourceColumnNullMapping="False"
> SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="Currency" Direction="Input"
> ParameterName="@ShipCost" Precision="0" ProviderType="Money" Scale="0"
> Size="0" SourceColumn="ShipCost" SourceColumnNullMapping="False"
> SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="Currency" Direction="Input"
> ParameterName="@OrderTotal" Precision="0" ProviderType="Money" Scale="0"
> Size="0" SourceColumn="OrderTotal" SourceColumnNullMapping="False"
> SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="Currency" Direction="Input"
> ParameterName="@ChinaSurcharges" Precision="0" ProviderType="Money"
> Scale="0" Size="0" SourceColumn="ChinaSurcharges"
> SourceColumnNullMapping="False" SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="Currency" Direction="Input"
> ParameterName="@CrystalSurcharges" Precision="0" ProviderType="Money"
> Scale="0" Size="0" SourceColumn="CrystalSurcharges"
> SourceColumnNullMapping="False" SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="Currency" Direction="Input"
> ParameterName="@OtherSurcharges" Precision="0" ProviderType="Money"
> Scale="0" Size="0" SourceColumn="OtherSurcharges"
> SourceColumnNullMapping="False" SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input"
> ParameterName="@Order_StaffKeyID" Precision="0" ProviderType="Char"
> Scale="0" Size="0" SourceColumn="Order_StaffKeyID"
> SourceColumnNullMapping="False" SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Paid"
> Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Paid"
> SourceColumnNullMapping="False" SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="String" Direction="Input"
> ParameterName="@ShiptoCompany" Precision="0" ProviderType="NVarChar"
> Scale="0" Size="0" SourceColumn="ShiptoCompany"
> SourceColumnNullMapping="False" SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="String" Direction="Input"
> ParameterName="@ShiptoName" Precision="0" ProviderType="NVarChar" Scale="0"
> Size="0" SourceColumn="ShiptoName" SourceColumnNullMapping="False"
> SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="String" Direction="Input"
> ParameterName="@ShipToAddress" Precision="0" ProviderType="NVarChar"
> Scale="0" Size="0" SourceColumn="ShipToAddress"
> SourceColumnNullMapping="False" SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="String" Direction="Input"
> ParameterName="@ShipToAddress2" Precision="0" ProviderType="NVarChar"
> Scale="0" Size="0" SourceColumn="ShipToAddress2"
> SourceColumnNullMapping="False" SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="Int32" Direction="Input"
> ParameterName="@ShipCity" Precision="0" ProviderType="Int" Scale="0"
> Size="0" SourceColumn="ShipCity" SourceColumnNullMapping="False"
> SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="Int32" Direction="Input"
> ParameterName="@ShipCountry" Precision="0" ProviderType="Int" Scale="0"
> Size="0" SourceColumn="ShipCountry" SourceColumnNullMapping="False"
> SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="Int32" Direction="Input"
> ParameterName="@ShipState" Precision="0" ProviderType="Int" Scale="0"
> Size="0" SourceColumn="ShipState" SourceColumnNullMapping="False"
> SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="String" Direction="Input"
> ParameterName="@ZipCode" Precision="0" ProviderType="NVarChar" Scale="0"
> Size="0" SourceColumn="ZipCode" SourceColumnNullMapping="False"
> SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="Boolean" Direction="Input"
> ParameterName="@SignRqByPassReport" Precision="0" ProviderType="Bit"
> Scale="0" Size="0" SourceColumn="SignRqByPassReport"
> SourceColumnNullMapping="False" SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input"
> ParameterName="@Final_CarrierCode" Precision="0" ProviderType="Char"
> Scale="0" Size="0" SourceColumn="Final_CarrierCode"
> SourceColumnNullMapping="False" SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input"
> ParameterName="@Final_ShippingServiceID" Precision="0" ProviderType="Char"
> Scale="0" Size="0" SourceColumn="Final_ShippingServiceID"
> SourceColumnNullMapping="False" SourceVersion="Current">
>                       </Parameter>
>                       <Parameter AllowDbNull="True" AutogeneratedName=""
> DataSourceName="" DbType="Int16" Direction="Input"
> ParameterName="@Final_NumPkgs" Precision="0" ProviderType="SmallInt"
> Scale="0" Size="0" SourceColumn="Final_NumPkgs"
> SourceColumnNullMapping="False" SourceVersion="Current">
>                       </Parameter>

Author
23 Jan 2006 5:58 AM
Steven Cheng[MSFT]
You're welcome Tdar,

Actually, it is hard to say that this is a bug since the table dosn't have
a explict primary key so that the auto generated code and 
datasource and databound control template need a bit further adjustment.
Anyway, you can post your requests on this so as to help us collect more
feedbacks on the new controls:)

http://lab.msdn.microsoft.com/productfeedback/default.aspx

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
--------------------
| Thread-Topic: detailsview,
| thread-index: AcYd7xv5ctzoFdz8TuSbFr5hh/KO7g==
| X-WBNR-Posting-Host: 24.73.223.27
| From: "=?Utf-8?B?VGRhclRkYXI=?=" <Tdar@noemail.nospam>
| References:  <9FAE7DE0-27D3-4015-8BFC-4F83ABC57***@microsoft.com>
<ndiBcinGGHA.1***@TK2MSFTNGXA02.phx.gbl>
<6D608EE7-507F-41F2-9432-5703C2468***@microsoft.com>
<1CQox5AHGHA.***@TK2MSFTNGXA02.phx.gbl>
<E94B931A-E3B1-4932-A9B1-AD0195660***@microsoft.com>
<bBwqGaYHGHA.3***@TK2MSFTNGXA02.phx.gbl>
Show quoteHide quote
| Subject: RE: detailsview,
| Date: Fri, 20 Jan 2006 10:27:03 -0800
| Lines: 309
| Message-ID: <9C241AF2-0670-4664-A573-D4484B087***@microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
|     charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.dotnet.framework.aspnet.webcontrols
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.dotnet.framework.aspnet.webcontrols:32683
Show quoteHide quote
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webcontrols
|
| Excelent that works, I assume that this will be put on the bug
| list to get fixed.
|
| thanks for your help
|
| Tdar
|
| "Steven Cheng[MSFT]" wrote:
|
| > Hi Tdar,
| >
| > I've performed some further tests through the test data you provided,
and I
| > did encounter some problem when using the autogenerated TypeDataSet/
| > TableAdapter (and bind to objectdatasource and DetailsView...). 
Actually,
| > the test table you provide doesn't specify a primary key column ( i
| > manually set the "ShipKey" as the pk...) , then creating the the
| > TableAdapter/DataSet from that table, and the  when using the
| > ObjectDataSource with the TableAdapter, it will set the
DataObjectTypeName
| > to "System.Guid", this is not correct, we can remove that attribute ,
or
| > make it empty......
| >
| > Then, when bind the objectdatasource to DetailsView control, it  will
make
| > the "ShipKey" field as readonly bydefault (as it is primary key), e.g:
| >
| > <asp:BoundField DataField="ShipKey" HeaderText="ShipKey" 
| > SortExpression="ShipKey"  ReadOnly="true" />
| >
| > this will make the ShipKey value not passed when performing update
| > operation. we can just remove the ReadOnly attribute or set it to false
,
| > thus when updating item, the ShipKey value will also be passed...., so
my
| > current  test DataSet code and page code is like:
| >
| > =========dataset============
| > <?xml version="1.0" encoding="utf-8"?>
| > <xs:schema id="OrderShipDS"
| > targetNamespace="http://tempuri.org/OrderShipDS.xsd"
| > xmlns:mstns="http://tempuri.org/OrderShipDS.xsd"
| > xmlns="http://tempuri.org/OrderShipDS.xsd"
| > xmlns:xs="http://www.w3.org/2001/XMLSchema"
| > xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
| > xmlns:msprop="urn:schemas-microsoft-com:xml-msprop"
| > attributeFormDefault="qualified" elementFormDefault="qualified">
| >   <xs:annotation>
| >     <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
| >       <DataSource DefaultConnectionIndex="0"
| > FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout,
| > AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema"
| > xmlns="urn:schemas-microsoft-com:xml-msdatasource">
| >         <Connections>
| >           <Connection AppSettingsObjectName="Web.config"
| > AppSettingsPropertyName="testdbConnectionString"
ConnectionStringObject=""
| > IsAppSettingsProperty="True" Modifier="Assembly"
| > Name="testdbConnectionString (Web.config)" ParameterPrefix="@"
| >
PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.Con
| > nectionStrings.testdbConnectionString.ConnectionString"
| > Provider="System.Data.SqlClient">
| >           </Connection>
| >         </Connections>
| >         <Tables>
| >           <TableAdapter BaseClass="System.ComponentModel.Component"
| > DataAccessorModifier="AutoLayout, AnsiClass, Class, Public"
| > DataAccessorName="OrderShipRecordTableAdapter"
| > GeneratorDataComponentClassName="OrderShipRecordTableAdapter"
| > Name="OrderShipRecord"
UserDataComponentName="OrderShipRecordTableAdapter">
| >             <MainSource>
| >               <DbSource ConnectionRef="testdbConnectionString
(Web.config)"
| > DbObjectName="testdb.dbo.OrderShipRecord" DbObjectType="Table"
| > FillMethodModifier="Public" FillMethodName="Fill"
GenerateMethods="Both"
| > GenerateShortCommands="True" GeneratorGetMethodName="GetData"
| > GeneratorSourceName="Fill" GetMethodModifier="Public"
| > GetMethodName="GetData" QueryType="Rowset"
ScalarCallRetval="System.Object,
Show quoteHide quote
| > mscorlib, Version=2.0.0.0, Culture=neutral,
| > PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False"
| > UserGetMethodName="GetData" UserSourceName="Fill">
| >                 <DeleteCommand>
| >                   <DbCommand CommandType="Text" ModifiedByUser="False">
| >                     <CommandText>DELETE FROM [OrderShipRecord] WHERE
| > (([ShipKey] = @Original_ShipKey))</CommandText>
| >                     <Parameters>
| >                       <Parameter AllowDbNull="False"
AutogeneratedName=""
| > DataSourceName="" DbType="Guid" Direction="Input"
| > ParameterName="@Original_ShipKey" Precision="0"
| > ProviderType="UniqueIdentifier" Scale="0" Size="0"
SourceColumn="ShipKey"
| > SourceColumnNullMapping="False" SourceVersion="Original">
| >                       </Parameter>
| >                     </Parameters>
| >                   </DbCommand>
| >                 </DeleteCommand>
| >                 <InsertCommand>
| >                   <DbCommand CommandType="Text" ModifiedByUser="False">
| >                     <CommandText>INSERT INTO [OrderShipRecord]
([ShipKey],
| > [DBMANTransNumber], [CreatedDate], [PackagedDate], [UserId],
[CarrierCode],
| > [LocationCode], [ShippingServiceID], [ShipInsuranceID], [OrderTypeRWC],
| > [SignatureReq], [HighValueFlag], [ShipCost], [OrderTotal],
| > [ChinaSurcharges], [CrystalSurcharges], [OtherSurcharges],
| > [Order_StaffKeyID], [Paid], [ShiptoCompany], [ShiptoName],
[ShipToAddress],
| > [ShipToAddress2], [ShipCity], [ShipCountry], [ShipState], [ZipCode],
| > [SignRqByPassReport], [Final_CarrierCode], [Final_ShippingServiceID],
| > [Final_NumPkgs], [Final_ShipCost], [Final_DeclaredValue],
| > [Final_CODAmount], [Final_Zone], [Final_FreightCharge], [Final_Weight],
| > [Final_ShipDate], [UPS_ShipCost], [UPS_Signature], [UPS_Delivered],
| > [UPS_DeliveredDate], [Org_Company], [Org_Name], [Org_Address],
[Org_City],
| > [Org_State], [Org_Zip], [ORG_DbmanShipmtd], [ORG_dbmanShipMNW],
| > [ORG_DBMANsalesCode], [ORG_2ndODRTot], [org_shiptran1], [org_airbill1],
| > [Org_Airbill2], [Org_SplitODRStus], [ORG_PakDate], [ORG_PakDate2],
| > [DBMAN_STATUS], [DBMANSURCHARGES], [EMAIL], [Breakable],
| > [DBMAN_OrderTotal], [ORG_DEPARTMENT], [ORG_PREMIUMBR], [CODE],
[APPRSCDE])
| > VALUES (@ShipKey, @DBMANTransNumber, @CreatedDate, @PackagedDate,
@UserId,
| > @CarrierCode, @LocationCode, @ShippingServiceID, @ShipInsuranceID,
| > @OrderTypeRWC, @SignatureReq, @HighValueFlag, @ShipCost, @OrderTotal,
| > @ChinaSurcharges, @CrystalSurcharges, @OtherSurcharges,
@Order_StaffKeyID,
| > @Paid, @ShiptoCompany, @ShiptoName, @ShipToAddress, @ShipToAddress2,
| > @ShipCity, @ShipCountry, @ShipState, @ZipCode, @SignRqByPassReport,
| > @Final_CarrierCode, @Final_ShippingServiceID, @Final_NumPkgs,
| > @Final_ShipCost, @Final_DeclaredValue, @Final_CODAmount, @Final_Zone,
| > @Final_FreightCharge, @Final_Weight, @Final_ShipDate, @UPS_ShipCost,
| > @UPS_Signature, @UPS_Delivered, @UPS_DeliveredDate, @Org_Company,
| > @Org_Name, @Org_Address, @Org_City, @Org_State, @Org_Zip,
| > @ORG_DbmanShipmtd, @ORG_dbmanShipMNW, @ORG_DBMANsalesCode,
@ORG_2ndODRTot,
| > @org_shiptran1, @org_airbill1, @Org_Airbill2, @Org_SplitODRStus,
| > @ORG_PakDate, @ORG_PakDate2, @DBMAN_STATUS, @DBMANSURCHARGES, @EMAIL,
| > @Breakable, @DBMAN_OrderTotal, @ORG_DEPARTMENT, @ORG_PREMIUMBR, @CODE,
| > @APPRSCDE)</CommandText>
| >                     <Parameters>
| >                       <Parameter AllowDbNull="False"
AutogeneratedName=""
| > DataSourceName="" DbType="Guid" Direction="Input"
ParameterName="@ShipKey"
| > Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0"
| > SourceColumn="ShipKey" SourceColumnNullMapping="False"
| > SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="False"
AutogeneratedName=""
| > DataSourceName="" DbType="String" Direction="Input"
| > ParameterName="@DBMANTransNumber" Precision="0" ProviderType="NVarChar"
| > Scale="0" Size="0" SourceColumn="DBMANTransNumber"
| > SourceColumnNullMapping="False" SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="False"
AutogeneratedName=""
| > DataSourceName="" DbType="DateTime" Direction="Input"
| > ParameterName="@CreatedDate" Precision="0" ProviderType="DateTime"
| > Scale="0" Size="0" SourceColumn="CreatedDate"
| > SourceColumnNullMapping="False" SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="DateTime" Direction="Input"
| > ParameterName="@PackagedDate" Precision="0" ProviderType="DateTime"
| > Scale="0" Size="0" SourceColumn="PackagedDate"
| > SourceColumnNullMapping="False" SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="False"
AutogeneratedName=""
| > DataSourceName="" DbType="Guid" Direction="Input"
ParameterName="@UserId"
| > Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0"
| > SourceColumn="UserId" SourceColumnNullMapping="False"
| > SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input"
| > ParameterName="@CarrierCode" Precision="0" ProviderType="Char"
Scale="0"
| > Size="0" SourceColumn="CarrierCode" SourceColumnNullMapping="False"
| > SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input"
| > ParameterName="@LocationCode" Precision="0" ProviderType="Char"
Scale="0"
| > Size="0" SourceColumn="LocationCode" SourceColumnNullMapping="False"
| > SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input"
| > ParameterName="@ShippingServiceID" Precision="0" ProviderType="Char"
| > Scale="0" Size="0" SourceColumn="ShippingServiceID"
| > SourceColumnNullMapping="False" SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input"
| > ParameterName="@ShipInsuranceID" Precision="0" ProviderType="Char"
| > Scale="0" Size="0" SourceColumn="ShipInsuranceID"
| > SourceColumnNullMapping="False" SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input"
| > ParameterName="@OrderTypeRWC" Precision="0" ProviderType="Char"
Scale="0"
| > Size="0" SourceColumn="OrderTypeRWC" SourceColumnNullMapping="False"
| > SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="Boolean" Direction="Input"
| > ParameterName="@SignatureReq" Precision="0" ProviderType="Bit"
Scale="0"
| > Size="0" SourceColumn="SignatureReq" SourceColumnNullMapping="False"
| > SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="Boolean" Direction="Input"
| > ParameterName="@HighValueFlag" Precision="0" ProviderType="Bit"
Scale="0"
| > Size="0" SourceColumn="HighValueFlag" SourceColumnNullMapping="False"
| > SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="Currency" Direction="Input"
| > ParameterName="@ShipCost" Precision="0" ProviderType="Money" Scale="0"
| > Size="0" SourceColumn="ShipCost" SourceColumnNullMapping="False"
| > SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="Currency" Direction="Input"
| > ParameterName="@OrderTotal" Precision="0" ProviderType="Money"
Scale="0"
| > Size="0" SourceColumn="OrderTotal" SourceColumnNullMapping="False"
| > SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="Currency" Direction="Input"
| > ParameterName="@ChinaSurcharges" Precision="0" ProviderType="Money"
| > Scale="0" Size="0" SourceColumn="ChinaSurcharges"
| > SourceColumnNullMapping="False" SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="Currency" Direction="Input"
| > ParameterName="@CrystalSurcharges" Precision="0" ProviderType="Money"
| > Scale="0" Size="0" SourceColumn="CrystalSurcharges"
| > SourceColumnNullMapping="False" SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="Currency" Direction="Input"
| > ParameterName="@OtherSurcharges" Precision="0" ProviderType="Money"
| > Scale="0" Size="0" SourceColumn="OtherSurcharges"
| > SourceColumnNullMapping="False" SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input"
| > ParameterName="@Order_StaffKeyID" Precision="0" ProviderType="Char"
| > Scale="0" Size="0" SourceColumn="Order_StaffKeyID"
| > SourceColumnNullMapping="False" SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="Boolean" Direction="Input"
ParameterName="@Paid"
| > Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Paid"
| > SourceColumnNullMapping="False" SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="String" Direction="Input"
| > ParameterName="@ShiptoCompany" Precision="0" ProviderType="NVarChar"
| > Scale="0" Size="0" SourceColumn="ShiptoCompany"
| > SourceColumnNullMapping="False" SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="String" Direction="Input"
| > ParameterName="@ShiptoName" Precision="0" ProviderType="NVarChar"
Scale="0"
| > Size="0" SourceColumn="ShiptoName" SourceColumnNullMapping="False"
| > SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="String" Direction="Input"
| > ParameterName="@ShipToAddress" Precision="0" ProviderType="NVarChar"
| > Scale="0" Size="0" SourceColumn="ShipToAddress"
| > SourceColumnNullMapping="False" SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="String" Direction="Input"
| > ParameterName="@ShipToAddress2" Precision="0" ProviderType="NVarChar"
| > Scale="0" Size="0" SourceColumn="ShipToAddress2"
| > SourceColumnNullMapping="False" SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="Int32" Direction="Input"
| > ParameterName="@ShipCity" Precision="0" ProviderType="Int" Scale="0"
| > Size="0" SourceColumn="ShipCity" SourceColumnNullMapping="False"
| > SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="Int32" Direction="Input"
| > ParameterName="@ShipCountry" Precision="0" ProviderType="Int" Scale="0"
| > Size="0" SourceColumn="ShipCountry" SourceColumnNullMapping="False"
| > SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="Int32" Direction="Input"
| > ParameterName="@ShipState" Precision="0" ProviderType="Int" Scale="0"
| > Size="0" SourceColumn="ShipState" SourceColumnNullMapping="False"
| > SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="String" Direction="Input"
| > ParameterName="@ZipCode" Precision="0" ProviderType="NVarChar"
Scale="0"
| > Size="0" SourceColumn="ZipCode" SourceColumnNullMapping="False"
| > SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="Boolean" Direction="Input"
| > ParameterName="@SignRqByPassReport" Precision="0" ProviderType="Bit"
| > Scale="0" Size="0" SourceColumn="SignRqByPassReport"
| > SourceColumnNullMapping="False" SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input"
| > ParameterName="@Final_CarrierCode" Precision="0" ProviderType="Char"
| > Scale="0" Size="0" SourceColumn="Final_CarrierCode"
| > SourceColumnNullMapping="False" SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input"
| > ParameterName="@Final_ShippingServiceID" Precision="0"
ProviderType="Char"
| > Scale="0" Size="0" SourceColumn="Final_ShippingServiceID"
| > SourceColumnNullMapping="False" SourceVersion="Current">
| >                       </Parameter>
| >                       <Parameter AllowDbNull="True"
AutogeneratedName=""
| > DataSourceName="" DbType="Int16" Direction="Input"
| > ParameterName="@Final_NumPkgs" Precision="0" ProviderType="SmallInt"
| > Scale="0" Size="0" SourceColumn="Final_NumPkgs"
| > SourceColumnNullMapping="False" SourceVersion="Current">
| >                       </Parameter>
|



Post Other interesting topics
ITemplate - Dynamic ImageButton in BindLabelColumn for DataList
SelectedValue which is invalid
Getting value from child control of formview
Embedding CSS with inline code
SmartNavigation Problem/Bug
Reports and the ReportViewer
GridView Data Binding at runtime
Dataset from ObjectDataSource always null?
GUID and data controls
Design Time referencing of Properties