detailsview,

13 Jan 2006 8:56 PM

TdarTdar

Why would i get this error:
Could not find a property named 'DBMANTransNumber' on the type specified by
the DataObjectTypeName property in ObjectDataSource 'ObjectDataSource1'.

Here what I am doing, I am using a dataset completly setup by the wizards
under the app_code directory, I do a simple "Select * from ordershiprecord
where ShipKey = @ShipKey" click next, leave fill a datatable, return a
datatable, create methods to send updates directly to the
database(generateDBDirectMethods) all checked, THen click next again, it says
it generated select, update, delete, table mappings, fil method, update
methods...

Then i go to a new web form and drag in a detailsview, choose new datasource,
object, select the "DJP_DataSet1TableAdpters.OrderShipRecordTableAdapter"
that is in the drop down. Click next, look around to see that the

select(GetData(Guid ShipKey), returns OrderShipRecordDataTable)

update(Update(String DBMANTransNumber, Guid UserId, String ShiptoCompany,
String ShiptoName, String ShipToAddress, String ShipToAddress2,
Nullable<Int32> ShipCity, Nullable<Int32> ShipCountry, Nullable<Int32>
ShipState, String ZipCode, Nullable<Boolean> SignatureReq, Guid ShipKey, Guid
Original_ShipKey), returns Int32)

delete(Delete(Guid Original_ShipKey), returns Int32) method is there

Click next
it asks to defind Parameters ... QueryString ... Querystringfield = ShipKey
Click Finish...

Page is created
Select enable editing and save the page

Run the calling page from visual studio...
type in shipkey and call the page
it shows me the records details just fine
so i click Edit to change a value
changed Signaturereq and selected Update.

I get:
---------------------------------------
Could not find a property named 'DBMANTransNumber' on the type specified by
the DataObjectTypeName property in ObjectDataSource 'ObjectDataSource1'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Could not find a
property named 'DBMANTransNumber' on the type specified by the
DataObjectTypeName property in ObjectDataSource 'ObjectDataSource1'.

Source Error:

An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: Could not find a property named
'DBMANTransNumber' on the type specified by the DataObjectTypeName property
in ObjectDataSource 'ObjectDataSource1'.]
   System.Web.UI.WebControls.ObjectDataSourceView.BuildDataObject(Type
dataObjectType, IDictionary inputParameters) +380
   System.Web.UI.WebControls.ObjectDataSourceView.ExecuteUpdate(IDictionary
keys, IDictionary values, IDictionary oldValues) +1512
   System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values,
IDictionary oldValues, DataSourceViewOperationCallback callback) +179
   System.Web.UI.WebControls.DetailsView.HandleUpdate(String commandArg,
Boolean causesValidation) +1197
   System.Web.UI.WebControls.DetailsView.HandleEvent(EventArgs e, Boolean
causesValidation, String validationGroup) +545
   System.Web.UI.WebControls.DetailsView.OnBubbleEvent(Object source,
EventArgs e) +162
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +56
   System.Web.UI.WebControls.DetailsViewRow.OnBubbleEvent(Object source,
EventArgs e) +117
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +56
   System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +106
   System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String
eventArgument) +175

System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +31
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +32
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +244
   System.Web.UI.
-------------------------------------------

So why when using the wizards would this happen, how do i solve this and
move on....

Tdar

16 Jan 2006 8:41 AM

Steven Cheng[MSFT]

Hi Tdar,

Welcome to ASPNET newsgroup.
From your description, you're using a certain TypedDataset(TableAdapter?)
to return some Data records through datatable and some certain methods for
update and delete. And you configure the Data Access component through
ObjectDataSource , it can display data well, however, when try performing
update operation, there raise some exception indicate that the certain
class lack of certain properties... yes?

Based on my experience, this is likely caused by the the DataAccess
component class's Update method's parameters list dosn't match the
DataBound control's supplied parameters.... As the error message
indicated:
=====================
Could not find a property named 'DBMANTransNumber' on the type specified by
the DataObjectTypeName property in ObjectDataSource 'ObjectDataSource1'.
=====================

So you can check the update parameters in the DataBound control (or you can
use the Updating event to printout all the supplief update parameters...).
Those parameters will be used by the ObjectDataSource control so as to mapp
them to each of the parameters in the Update method or properties of the
Data Object configured in ObjectDataSource (as parameter in the Update
method...)..

In addition, if convenient, would you post some further detailed code
snippet and aspx template on the ObjectDataSource, DataBound control and
the typed dataset so that we can have a look on them?

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

--------------------
Show quoteHide quote

microsoft.public.dotnet.framework.aspnet.webcontrols:32460
Show quoteHide quote

| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webcontrols
|
| Why would i get this error:
| Could not find a property named 'DBMANTransNumber' on the type specified
by
| the DataObjectTypeName property in ObjectDataSource 'ObjectDataSource1'.
|
| Here what I am doing, I am using a dataset completly setup by the wizards
| under the app_code directory, I do a simple "Select * from
ordershiprecord
| where ShipKey = @ShipKey" click next, leave fill a datatable, return a
| datatable, create methods to send updates directly to the
| database(generateDBDirectMethods) all checked, THen click next again, it
says
| it generated select, update, delete, table mappings, fil method, update
| methods...
|
| Then i go to a new web form and drag in a detailsview, choose new
datasource,
| object, select the "DJP_DataSet1TableAdpters.OrderShipRecordTableAdapter"
| that is in the drop down. Click next, look around to see that the
|
| select(GetData(Guid ShipKey), returns OrderShipRecordDataTable)
|
| update(Update(String DBMANTransNumber, Guid UserId, String ShiptoCompany,
| String ShiptoName, String ShipToAddress, String ShipToAddress2,
| Nullable<Int32> ShipCity, Nullable<Int32> ShipCountry, Nullable<Int32>
| ShipState, String ZipCode, Nullable<Boolean> SignatureReq, Guid ShipKey,
Guid
| Original_ShipKey), returns Int32)
|
| delete(Delete(Guid Original_ShipKey), returns Int32) method is there
|
| Click next
| it asks to defind Parameters ... QueryString ... Querystringfield =
ShipKey
| Click Finish...
|
| Page is created
| Select enable editing and save the page
|
| Run the calling page from visual studio...
| type in shipkey and call the page
| it shows me the records details just fine
| so i click Edit to change a value
| changed Signaturereq and selected Update.
|
| I get:
| ---------------------------------------
| Could not find a property named 'DBMANTransNumber' on the type specified
by
| the DataObjectTypeName property in ObjectDataSource 'ObjectDataSource1'.
| Description: An unhandled exception occurred during the execution of the
| current web request. Please review the stack trace for more information
about
| the error and where it originated in the code.
|
| Exception Details: System.InvalidOperationException: Could not find a
| property named 'DBMANTransNumber' on the type specified by the
| DataObjectTypeName property in ObjectDataSource 'ObjectDataSource1'.
|
| Source Error:
|
| An unhandled exception was generated during the execution of the current
web
| request. Information regarding the origin and location of the exception
can
| be identified using the exception stack trace below.
|
| Stack Trace:
|
|
| [InvalidOperationException: Could not find a property named
| 'DBMANTransNumber' on the type specified by the DataObjectTypeName
property
| in ObjectDataSource 'ObjectDataSource1'.]
| System.Web.UI.WebControls.ObjectDataSourceView.BuildDataObject(Type
| dataObjectType, IDictionary inputParameters) +380
|

System.Web.UI.WebControls.ObjectDataSourceView.ExecuteUpdate(IDictionary
Show quoteHide quote

| keys, IDictionary values, IDictionary oldValues) +1512
|    System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary
values,
| IDictionary oldValues, DataSourceViewOperationCallback callback) +179
|    System.Web.UI.WebControls.DetailsView.HandleUpdate(String commandArg,
| Boolean causesValidation) +1197
|    System.Web.UI.WebControls.DetailsView.HandleEvent(EventArgs e, Boolean
| causesValidation, String validationGroup) +545
|    System.Web.UI.WebControls.DetailsView.OnBubbleEvent(Object source,
| EventArgs e) +162
|    System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
+56
|    System.Web.UI.WebControls.DetailsViewRow.OnBubbleEvent(Object source,
| EventArgs e) +117
|    System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
+56
|    System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +106
|    System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String
| eventArgument) +175
|
|

System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.Rai
sePostBackEvent(String eventArgument) +31
Show quoteHide quote

|    System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
| sourceControl, String eventArgument) +32
|    System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
+244
|    System.Web.UI.
| -------------------------------------------
|
|
| So why when using the wizards would this happen, how do i solve this and
| move on....
|
| Tdar
|
|
|
|

16 Jan 2006 4:08 PM

TdarTdar

Hi, as I said i used the wizards, and yes

> when try performing
> update operation, there raise some exception indicate that the certain
> class lack of certain properties... yes?

DJP_Dataset1:
====================
<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DJP_DataSet1"
targetNamespace="http://tempuri.org/DJP_DataSet1.xsd"
xmlns:mstns="http://tempuri.org/DJP_DataSet1.xsd"
xmlns="http://tempuri.org/DJP_DataSet1.xsd"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
xmlns:msprop="urn:schemas-microsoft-com:xml-msprop"
attributeFormDefault="qualified" elementFormDefault="qualified">
<xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0"
FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass,
Class, Public" SchemaSerializationMode="IncludeSchema"
xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config"
AppSettingsPropertyName="SilverQueen_Main_SystemConnectionString1"
ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly"
Name="SilverQueen_Main_SystemConnectionString1 (Web.config)"
ParameterPrefix="@"
PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.SilverQueen_Main_SystemConnectionString1.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="SilverQueen_Main_SystemConnectionString1 (Web.config)"
DbObjectName="SilverQueen_Main_System.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>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     DBMANTransNumber, UserId,
ShiptoCompany, ShiptoName, ShipToAddress, ShipToAddress2, ShipCity,
ShipCountry, ShipState, ZipCode,
                      SignatureReq, ShipKey
FROM         OrderShipRecord
WHERE     (ShipKey = @ShipKey)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False"
AutogeneratedName="ShipKey" ColumnName="ShipKey"
DataSourceName="SilverQueen_Main_System.dbo.OrderShipRecord"
DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input"
ParameterName="@ShipKey" Precision="0" ProviderType="UniqueIdentifier"
Scale="0" Size="16" SourceColumn="ShipKey" SourceColumnNullMapping="False"
SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [OrderShipRecord] SET
[DBMANTransNumber] = @DBMANTransNumber, [UserId] = @UserId, [ShiptoCompany] =
@ShiptoCompany, [ShiptoName] = @ShiptoName, [ShipToAddress] = @ShipToAddress,
[ShipToAddress2] = @ShipToAddress2, [ShipCity] = @ShipCity, [ShipCountry] =
@ShipCountry, [ShipState] = @ShipState, [ZipCode] = @ZipCode, [SignatureReq]
= @SignatureReq, [ShipKey] = @ShipKey WHERE (([ShipKey] =
@Original_ShipKey))</CommandText>
                    <Parameters>
                      <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="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="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="@SignatureReq" Precision="0" ProviderType="Bit" Scale="0"
Size="0" SourceColumn="SignatureReq" SourceColumnNullMapping="False"
SourceVersion="Current">
                      </Parameter>
                      <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="Guid" Direction="Input"
ParameterName="@Original_ShipKey" Precision="0"
ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ShipKey"
SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="DBMANTransNumber"
DataSetColumn="DBMANTransNumber" />
              <Mapping SourceColumn="UserId" DataSetColumn="UserId" />
              <Mapping SourceColumn="ShiptoCompany"
DataSetColumn="ShiptoCompany" />
              <Mapping SourceColumn="ShiptoName" DataSetColumn="ShiptoName" />
              <Mapping SourceColumn="ShipToAddress"
DataSetColumn="ShipToAddress" />
              <Mapping SourceColumn="ShipToAddress2"
DataSetColumn="ShipToAddress2" />
              <Mapping SourceColumn="ShipCity" DataSetColumn="ShipCity" />
              <Mapping SourceColumn="ShipCountry"
DataSetColumn="ShipCountry" />
              <Mapping SourceColumn="ShipState" DataSetColumn="ShipState" />
              <Mapping SourceColumn="ZipCode" DataSetColumn="ZipCode" />
              <Mapping SourceColumn="SignatureReq"
DataSetColumn="SignatureReq" />
              <Mapping SourceColumn="ShipKey" DataSetColumn="ShipKey" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
</xs:annotation>
<xs:element name="DJP_DataSet1" msdata:IsDataSet="true"
msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DJP_DataSet1"
msprop:Generator_DataSetName="DJP_DataSet1">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="OrderShipRecord"
msprop:Generator_UserTableName="OrderShipRecord"
msprop:Generator_RowDeletedName="OrderShipRecordRowDeleted"
msprop:Generator_RowChangedName="OrderShipRecordRowChanged"
msprop:Generator_RowClassName="OrderShipRecordRow"
msprop:Generator_RowChangingName="OrderShipRecordRowChanging"
msprop:Generator_RowEvArgName="OrderShipRecordRowChangeEvent"
msprop:Generator_RowEvHandlerName="OrderShipRecordRowChangeEventHandler"
msprop:Generator_TableClassName="OrderShipRecordDataTable"
msprop:Generator_TableVarName="tableOrderShipRecord"
msprop:Generator_RowDeletingName="OrderShipRecordRowDeleting"
msprop:Generator_TablePropName="OrderShipRecord">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DBMANTransNumber"
msprop:Generator_UserColumnName="DBMANTransNumber"
msprop:Generator_ColumnVarNameInTable="columnDBMANTransNumber"
msprop:Generator_ColumnPropNameInRow="DBMANTransNumber"
msprop:Generator_ColumnPropNameInTable="DBMANTransNumberColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserId" msdata:DataType="System.Guid,
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
msprop:Generator_UserColumnName="UserId"
msprop:Generator_ColumnVarNameInTable="columnUserId"
msprop:Generator_ColumnPropNameInRow="UserId"
msprop:Generator_ColumnPropNameInTable="UserIdColumn" type="xs:string" />
              <xs:element name="ShiptoCompany"
msprop:Generator_UserColumnName="ShiptoCompany"
msprop:Generator_ColumnVarNameInTable="columnShiptoCompany"
msprop:Generator_ColumnPropNameInRow="ShiptoCompany"
msprop:Generator_ColumnPropNameInTable="ShiptoCompanyColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShiptoName"
msprop:Generator_UserColumnName="ShiptoName"
msprop:Generator_ColumnVarNameInTable="columnShiptoName"
msprop:Generator_ColumnPropNameInRow="ShiptoName"
msprop:Generator_ColumnPropNameInTable="ShiptoNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShipToAddress"
msprop:Generator_UserColumnName="ShipToAddress"
msprop:Generator_ColumnVarNameInTable="columnShipToAddress"
msprop:Generator_ColumnPropNameInRow="ShipToAddress"
msprop:Generator_ColumnPropNameInTable="ShipToAddressColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShipToAddress2"
msprop:Generator_UserColumnName="ShipToAddress2"
msprop:Generator_ColumnVarNameInTable="columnShipToAddress2"
msprop:Generator_ColumnPropNameInRow="ShipToAddress2"
msprop:Generator_ColumnPropNameInTable="ShipToAddress2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="80" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShipCity"
msprop:Generator_UserColumnName="ShipCity"
msprop:Generator_ColumnVarNameInTable="columnShipCity"
msprop:Generator_ColumnPropNameInRow="ShipCity"
msprop:Generator_ColumnPropNameInTable="ShipCityColumn" type="xs:int"
minOccurs="0" />
              <xs:element name="ShipCountry"
msprop:Generator_UserColumnName="ShipCountry"
msprop:Generator_ColumnVarNameInTable="columnShipCountry"
msprop:Generator_ColumnPropNameInRow="ShipCountry"
msprop:Generator_ColumnPropNameInTable="ShipCountryColumn" type="xs:int"
minOccurs="0" />
              <xs:element name="ShipState"
msprop:Generator_UserColumnName="ShipState"
msprop:Generator_ColumnVarNameInTable="columnShipState"
msprop:Generator_ColumnPropNameInRow="ShipState"
msprop:Generator_ColumnPropNameInTable="ShipStateColumn" type="xs:int"
minOccurs="0" />
              <xs:element name="ZipCode"
msprop:Generator_UserColumnName="ZipCode"
msprop:Generator_ColumnVarNameInTable="columnZipCode"
msprop:Generator_ColumnPropNameInRow="ZipCode"
msprop:Generator_ColumnPropNameInTable="ZipCodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SignatureReq"
msprop:Generator_UserColumnName="SignatureReq"
msprop:Generator_ColumnVarNameInTable="columnSignatureReq"
msprop:Generator_ColumnPropNameInRow="SignatureReq"
msprop:Generator_ColumnPropNameInTable="SignatureReqColumn" type="xs:boolean"
minOccurs="0" />
              <xs:element name="ShipKey" msdata:DataType="System.Guid,
mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
msprop:Generator_UserColumnName="ShipKey"
msprop:Generator_ColumnVarNameInTable="columnShipKey"
msprop:Generator_ColumnPropNameInRow="ShipKey"
msprop:Generator_ColumnPropNameInTable="ShipKeyColumn" type="xs:string" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:OrderShipRecord" />
      <xs:field xpath="mstns:ShipKey" />
    </xs:unique>
</xs:element>
</xs:schema>
====================================
This previous dataset that was created by the wizards brings up 53 warnings
and 43 messages, but no errors, FYI..

Page code:

showshipdetails.aspx:
==================================

<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False"
        DataKeyNames="ShipKey" DataSourceID="ObjectDataSource1"
Height="50px" Width="125px">
        <Fields>
            <asp:BoundField DataField="DBMANTransNumber"
HeaderText="DBMANTransNumber" SortExpression="DBMANTransNumber" />
            <asp:BoundField DataField="UserId" HeaderText="UserId"
SortExpression="UserId" />
            <asp:BoundField DataField="ShiptoCompany"
HeaderText="ShiptoCompany" SortExpression="ShiptoCompany" />
            <asp:BoundField DataField="ShiptoName" HeaderText="ShiptoName"
SortExpression="ShiptoName" />
            <asp:BoundField DataField="ShipToAddress"
HeaderText="ShipToAddress" SortExpression="ShipToAddress" />
            <asp:BoundField DataField="ShipToAddress2"
HeaderText="ShipToAddress2" SortExpression="ShipToAddress2" />
            <asp:BoundField DataField="ShipCity" HeaderText="ShipCity"
SortExpression="ShipCity" />
            <asp:BoundField DataField="ShipCountry" HeaderText="ShipCountry"
SortExpression="ShipCountry" />
            <asp:BoundField DataField="ShipState" HeaderText="ShipState"
SortExpression="ShipState" />
            <asp:BoundField DataField="ZipCode" HeaderText="ZipCode"
SortExpression="ZipCode" />
            <asp:CheckBoxField DataField="SignatureReq"
HeaderText="SignatureReq" SortExpression="SignatureReq" />
            <asp:BoundField DataField="ShipKey" HeaderText="ShipKey"
ReadOnly="True" SortExpression="ShipKey" />
            <asp:CommandField ShowEditButton="True" />
        </Fields>
    </asp:DetailsView>
    <asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
DataObjectTypeName="System.Guid"
        DeleteMethod="Delete" OldValuesParameterFormatString="original_{0}"
SelectMethod="GetData"
        TypeName="DJP_DataSet1TableAdapters.OrderShipRecordTableAdapter"
UpdateMethod="Update">
        <UpdateParameters>
            <asp:Parameter Name="DBMANTransNumber" Type="String" />
            <asp:Parameter Name="UserId" Type="Object" />
            <asp:Parameter Name="ShiptoCompany" Type="String" />
            <asp:Parameter Name="ShiptoName" Type="String" />
            <asp:Parameter Name="ShipToAddress" Type="String" />
            <asp:Parameter Name="ShipToAddress2" Type="String" />
            <asp:Parameter Name="ShipCity" Type="Int32" />
            <asp:Parameter Name="ShipCountry" Type="Int32" />
            <asp:Parameter Name="ShipState" Type="Int32" />
            <asp:Parameter Name="ZipCode" Type="String" />
            <asp:Parameter Name="SignatureReq" Type="Boolean" />
            <asp:Parameter Name="ShipKey" Type="Object" />
            <asp:Parameter Name="Original_ShipKey" Type="Object" />
        </UpdateParameters>
        <SelectParameters>
            <asp:QueryStringParameter Name="ShipKey"
QueryStringField="ShipKey" Type="Object" />
        </SelectParameters>
    </asp:ObjectDataSource>

==============================================

Show quoteHide quote

"Steven Cheng[MSFT]" wrote:

> Hi Tdar,
>
> Welcome to ASPNET newsgroup.
> From your description, you're using a certain TypedDataset(TableAdapter?)
> to return some Data records through datatable and some certain methods for
> update and delete. And you configure the Data Access component through
> ObjectDataSource , it can display data well, however, when try performing
> update operation, there raise some exception indicate that the certain
> class lack of certain properties... yes?
>
> Based on my experience, this is likely caused by the the DataAccess
> component class's Update method's parameters list dosn't match the
> DataBound control's supplied parameters....   As the error message
> indicated:
> =====================
> Could not find a property named 'DBMANTransNumber' on the type specified by
> the DataObjectTypeName property in ObjectDataSource 'ObjectDataSource1'.
> =====================
>
> So you can check the update parameters in the DataBound control (or you can
> use the Updating event to printout all the supplief update parameters...).
> Those parameters will be used by the ObjectDataSource control so as to mapp
> them to each of the parameters in the Update method or properties of the
> Data Object configured in ObjectDataSource (as parameter in the Update
> method...)..
>
> In addition, if convenient, would you post some further detailed code
> snippet and aspx template on the ObjectDataSource, DataBound control and
> the typed dataset so that we can have a look on them?
>
> Thanks,
>
> 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: AcYYg8SbbQRjhNvTTkSewzRImpqrOA==
> | X-WBNR-Posting-Host: 24.73.223.27
> | From: "=?Utf-8?B?VGRhclRkYXI=?=" <Tdar@noemail.nospam>
> | Subject: detailsview,
> | Date: Fri, 13 Jan 2006 12:56:04 -0800
> | Lines: 98
> | Message-ID: <9FAE7DE0-27D3-4015-8BFC-4F83ABC57***@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:32460
> | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webcontrols
> |
> | Why would i get this error:
> | Could not find a property named 'DBMANTransNumber' on the type specified
> by
> | the DataObjectTypeName property in ObjectDataSource 'ObjectDataSource1'.
> |
> | Here what I am doing, I am using a dataset completly setup by the wizards
> | under the app_code directory, I do a simple "Select * from
> ordershiprecord
> | where ShipKey = @ShipKey" click next, leave fill a datatable, return a
> | datatable, create methods to send updates directly to the
> | database(generateDBDirectMethods) all checked, THen click next again, it
> says
> | it generated select, update, delete, table mappings, fil method, update
> | methods...
> |
> | Then i go to a new web form and drag in a detailsview, choose new
> datasource,
> | object, select the "DJP_DataSet1TableAdpters.OrderShipRecordTableAdapter"
> | that is in the drop down. Click next, look around to see that the
> |
> | select(GetData(Guid ShipKey), returns OrderShipRecordDataTable)
> |
> | update(Update(String DBMANTransNumber, Guid UserId, String ShiptoCompany,
> | String ShiptoName, String ShipToAddress, String ShipToAddress2,
> | Nullable<Int32> ShipCity, Nullable<Int32> ShipCountry, Nullable<Int32>
> | ShipState, String ZipCode, Nullable<Boolean> SignatureReq, Guid ShipKey,
> Guid
> | Original_ShipKey), returns Int32)
> |
> | delete(Delete(Guid Original_ShipKey), returns Int32) method is there
> |
> | Click next
> | it asks to defind Parameters ... QueryString ... Querystringfield =
> ShipKey
> | Click Finish...
> |
> | Page is created
> | Select enable editing and save the page
> |
> | Run the calling page from visual studio...
> | type in shipkey and call the page
> | it shows me the records details just fine
> | so i click Edit to change a value
> | changed Signaturereq and selected Update.
> |
> | I get:
> | ---------------------------------------
> | Could not find a property named 'DBMANTransNumber' on the type specified
> by
> | the DataObjectTypeName property in ObjectDataSource 'ObjectDataSource1'.
> | Description: An unhandled exception occurred during the execution of the
> | current web request. Please review the stack trace for more information
> about
> | the error and where it originated in the code.
> |
> | Exception Details: System.InvalidOperationException: Could not find a
> | property named 'DBMANTransNumber' on the type specified by the
> | DataObjectTypeName property in ObjectDataSource 'ObjectDataSource1'.
> |
> | Source Error:
> |
> | An unhandled exception was generated during the execution of the current
> web
> | request. Information regarding the origin and location of the exception
> can
> | be identified using the exception stack trace below.
> |
> | Stack Trace:
> |
> |
> | [InvalidOperationException: Could not find a property named
> | 'DBMANTransNumber' on the type specified by the DataObjectTypeName
> property
> | in ObjectDataSource 'ObjectDataSource1'.]
> |    System.Web.UI.WebControls.ObjectDataSourceView.BuildDataObject(Type
> | dataObjectType, IDictionary inputParameters) +380
> |
> System.Web.UI.WebControls.ObjectDataSourceView.ExecuteUpdate(IDictionary
> | keys, IDictionary values, IDictionary oldValues) +1512
> |    System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary
> values,
> | IDictionary oldValues, DataSourceViewOperationCallback callback) +179
> |    System.Web.UI.WebControls.DetailsView.HandleUpdate(String commandArg,
> | Boolean causesValidation) +1197
> |    System.Web.UI.WebControls.DetailsView.HandleEvent(EventArgs e, Boolean
> | causesValidation, String validationGroup) +545
> |    System.Web.UI.WebControls.DetailsView.OnBubbleEvent(Object source,
> | EventArgs e) +162
> |    System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
> +56
> |    System.Web.UI.WebControls.DetailsViewRow.OnBubbleEvent(Object source,
> | EventArgs e) +117
> |    System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
> +56
> |    System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +106
> |    System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String
> | eventArgument) +175
> |
> |
> System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.Rai
> sePostBackEvent(String eventArgument) +31
> |    System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> | sourceControl, String eventArgument) +32
> |    System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
> +244
> |    System.Web.UI.
> | -------------------------------------------
> |
> |
> | So why when using the wizards would this happen, how do i solve this and
> | move on....
> |
> | Tdar
> |
> |
> |
> |
>
>

18 Jan 2006 9:06 AM

Steven Cheng[MSFT]

Hi Tdar,

I've just tried the dataset xml and db script you provided, seems the table
structure is very large which contains lots of columns, I can't quite get
how to fill some test data. If convenient would you also attache some test
data to me?

Also ,based on the ASP.NET page's aspx template you provided, I found that
you set the ObjectDataSource's DataObjectTypeName to "System.Guid", this
is incorrect since ObjectDataSource.DataObjectTypeName should be configured
to a type which contains the Properties that can mapped to all the
parameters in your update, insert methods....
You can view the description in the MSDN document:

#ObjectDataSource.DataObjectTypeName Property
http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.objectdat
asource.dataobjecttypename.aspx

So for your scenario I think the DataObjectTypeName should be configured to
"DJP_DataSet1.OrderShipRecordRow" ...

You can have a look , if anything unclear, please feel free to post here.

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: AcYatwcMewVhKBVrRJq376XEWAmeyA==
| 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>
Show quoteHide quote

microsoft.public.dotnet.framework.aspnet.webcontrols:32507
Show quoteHide quote

| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webcontrols
|
| Hi, as I said i used the wizards, and yes
| > when try performing
| > update operation, there raise some exception indicate that the certain
| > class lack of certain properties... yes?
|
| DJP_Dataset1:
| ====================
| <?xml version="1.0" encoding="utf-8"?>
| <xs:schema id="DJP_DataSet1"
| targetNamespace="http://tempuri.org/DJP_DataSet1.xsd"
| xmlns:mstns="http://tempuri.org/DJP_DataSet1.xsd"
| xmlns="http://tempuri.org/DJP_DataSet1.xsd"
| xmlns:xs="http://www.w3.org/2001/XMLSchema"
| xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
| xmlns:msprop="urn:schemas-microsoft-com:xml-msprop"
| attributeFormDefault="qualified" elementFormDefault="qualified">
|   <xs:annotation>
|     <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
|       <DataSource DefaultConnectionIndex="0"
| FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout,
AnsiClass,
| Class, Public" SchemaSerializationMode="IncludeSchema"
| xmlns="urn:schemas-microsoft-com:xml-msdatasource">
|         <Connections>
|           <Connection AppSettingsObjectName="Web.config"
| AppSettingsPropertyName="SilverQueen_Main_SystemConnectionString1"
| ConnectionStringObject="" IsAppSettingsProperty="True"
Modifier="Assembly"
| Name="SilverQueen_Main_SystemConnectionString1 (Web.config)"
| ParameterPrefix="@"
|

PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.Con
nectionStrings.SilverQueen_Main_SystemConnectionString1.ConnectionString"

UserDataComponentName="OrderShipRecordTableAdapter">
Show quoteHide quote

|             <MainSource>
|               <DbSource
| ConnectionRef="SilverQueen_Main_SystemConnectionString1 (Web.config)"
| DbObjectName="SilverQueen_Main_System.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>
|                 <SelectCommand>
|                   <DbCommand CommandType="Text" ModifiedByUser="True">
|                     <CommandText>SELECT     DBMANTransNumber, UserId,
| ShiptoCompany, ShiptoName, ShipToAddress, ShipToAddress2, ShipCity,
| ShipCountry, ShipState, ZipCode,
|                       SignatureReq, ShipKey
| FROM         OrderShipRecord
| WHERE     (ShipKey = @ShipKey)</CommandText>
|                     <Parameters>
|                       <Parameter AllowDbNull="False"
| AutogeneratedName="ShipKey" ColumnName="ShipKey"
| DataSourceName="SilverQueen_Main_System.dbo.OrderShipRecord"
| DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input"
| ParameterName="@ShipKey" Precision="0" ProviderType="UniqueIdentifier"
| Scale="0" Size="16" SourceColumn="ShipKey"
SourceColumnNullMapping="False"
| SourceVersion="Current">
|                       </Parameter>
|                     </Parameters>
|                   </DbCommand>
|                 </SelectCommand>
|                 <UpdateCommand>
|                   <DbCommand CommandType="Text" ModifiedByUser="False">
|                     <CommandText>UPDATE [OrderShipRecord] SET
| [DBMANTransNumber] = @DBMANTransNumber, [UserId] = @UserId,
[ShiptoCompany] =
| @ShiptoCompany, [ShiptoName] = @ShiptoName, [ShipToAddress] =
@ShipToAddress,
| [ShipToAddress2] = @ShipToAddress2, [ShipCity] = @ShipCity, [ShipCountry]
=
| @ShipCountry, [ShipState] = @ShipState, [ZipCode] = @ZipCode,
[SignatureReq]
| = @SignatureReq, [ShipKey] = @ShipKey WHERE (([ShipKey] =
| @Original_ShipKey))</CommandText>
|                     <Parameters>
|                       <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="Guid" Direction="Input" ParameterName="@UserId"
| Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0"
| SourceColumn="UserId" SourceColumnNullMapping="False"

SourceVersion="Current">
Show quoteHide quote

|                       </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="@SignatureReq" Precision="0" ProviderType="Bit" Scale="0"
| Size="0" SourceColumn="SignatureReq" SourceColumnNullMapping="False"
| SourceVersion="Current">
|                       </Parameter>
|                       <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="Guid" Direction="Input"
| ParameterName="@Original_ShipKey" Precision="0"
| ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ShipKey"
| SourceColumnNullMapping="False" SourceVersion="Original">
|                       </Parameter>
|                     </Parameters>
|                   </DbCommand>
|                 </UpdateCommand>
|               </DbSource>
|             </MainSource>
|             <Mappings>
|               <Mapping SourceColumn="DBMANTransNumber"
| DataSetColumn="DBMANTransNumber" />
|               <Mapping SourceColumn="UserId" DataSetColumn="UserId" />
|               <Mapping SourceColumn="ShiptoCompany"
| DataSetColumn="ShiptoCompany" />
|               <Mapping SourceColumn="ShiptoName"

DataSetColumn="ShiptoName" />
Show quoteHide quote

minOccurs="0">
Show quoteHide quote

minOccurs="0">

minOccurs="0">
Show quoteHide quote

type="xs:boolean"
Show quoteHide quote

OldValuesParameterFormatString="original_{0}"
Show quoteHide quote

Nullable<Int32>
Show quoteHide quote

| > | ShipState, String ZipCode, Nullable<Boolean> SignatureReq, Guid
ShipKey,
| > Guid
| > | Original_ShipKey), returns Int32)
| > |
| > | delete(Delete(Guid Original_ShipKey), returns Int32) method is there
| > |
| > | Click next
| > | it asks to defind Parameters ... QueryString ... Querystringfield =
| > ShipKey
| > | Click Finish...
| > |
| > | Page is created
| > | Select enable editing and save the page
| > |
| > | Run the calling page from visual studio...
| > | type in shipkey and call the page
| > | it shows me the records details just fine
| > | so i click Edit to change a value
| > | changed Signaturereq and selected Update.
| > |
| > | I get:
| > | ---------------------------------------
| > | Could not find a property named 'DBMANTransNumber' on the type
specified
| > by
| > | the DataObjectTypeName property in ObjectDataSource
'ObjectDataSource1'.
| > | Description: An unhandled exception occurred during the execution of
the
| > | current web request. Please review the stack trace for more
information
| > about
| > | the error and where it originated in the code.
| > |
| > | Exception Details: System.InvalidOperationException: Could not find a
| > | property named 'DBMANTransNumber' on the type specified by the
| > | DataObjectTypeName property in ObjectDataSource 'ObjectDataSource1'.
| > |
| > | Source Error:
| > |
| > | An unhandled exception was generated during the execution of the
current
| > web
| > | request. Information regarding the origin and location of the
exception
| > can
| > | be identified using the exception stack trace below.
| > |
| > | Stack Trace:
| > |
| > |
| > | [InvalidOperationException: Could not find a property named
| > | 'DBMANTransNumber' on the type specified by the DataObjectTypeName
| > property
| > | in ObjectDataSource 'ObjectDataSource1'.]
| > |

System.Web.UI.WebControls.ObjectDataSourceView.BuildDataObject(Type

| > | dataObjectType, IDictionary inputParameters) +380
| > |
| >

System.Web.UI.WebControls.ObjectDataSourceView.ExecuteUpdate(IDictionary
Show quoteHide quote

| > | keys, IDictionary values, IDictionary oldValues) +1512
| > |    System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary
| > values,
| > | IDictionary oldValues, DataSourceViewOperationCallback callback) +179
| > |    System.Web.UI.WebControls.DetailsView.HandleUpdate(String
commandArg,
| > | Boolean causesValidation) +1197
| > |    System.Web.UI.WebControls.DetailsView.HandleEvent(EventArgs e,
Boolean
| > | causesValidation, String validationGroup) +545
| > |    System.Web.UI.WebControls.DetailsView.OnBubbleEvent(Object source,
| > | EventArgs e) +162
| > |    System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs
args)
| > +56
| > |    System.Web.UI.WebControls.DetailsViewRow.OnBubbleEvent(Object
source,
| > | EventArgs e) +117
| > |    System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs
args)
| > +56
| > |    System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e)
+106
| > |    System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String
| > | eventArgument) +175
| > |
| > |
| >

System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.Rai
Show quoteHide quote

| > sePostBackEvent(String eventArgument) +31
| > |    System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
| > | sourceControl, String eventArgument) +32
| > |    System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
postData)
| > +244
| > |    System.Web.UI.
| > | -------------------------------------------
| > |
| > |
| > | So why when using the wizards would this happen, how do i solve this
and
| > | move on....
| > |
| > | Tdar
| > |
| > |
| > |
| > |
| >
| >
|

18 Jan 2006 4:59 PM

TdarTdar

Here is some test data,
========================== "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"
{69674EDE-17EE-4A95-9132-566E8A82D20D},"941823",2006-01-13
15:32:46.953000000,,{2F59D715-99DE-430B-BAAC-FE9752C1A3C7},"C","S","2","","R",,,,,,,,"",,"JOAN","ttt","2
test ln","",224,1,21,"21208",,"","",,,,,"",,"",,,"",,,"JOAN","ttt","2 test
ln","BALTIMORE","MD","21208","2","2","i
","0.00","941823-1","1ZEtest2","","Y         ","10/14/05"," / /
","PAID","0.00","te***@test.COM",,"177.25","S","0.00",False,""
{642C1827-B3E9-4C76-8679-5DAB622661C2},"509391",2006-01-18
10:41:04.543000000,,{2F59D715-99DE-430B-BAAC-FE9752C1A3C7},"C","S","5","","C",,,,,,,,"",,"BETH","ewr","3
test ln","",54,1,10,"33709",,"","",,,,,"",,"",,,"",,,"BETH","ewr","3 test
ln","SAINT PETERSBURG","FL","33709","U","5","S
","93.00","509391","","","          "," / / "," / /
","MEMO","0.00","",,"93.00","S","0.00",False,""
{E750B1A5-362B-4434-A0FC-CBE29EDFDF28},"499179",2006-01-18
10:41:12.793000000,,{2F59D715-99DE-430B-BAAC-FE9752C1A3C7},"C","S","5","","R",,,,,,,,"",,"DAVID","wew","10
10 TEST LN","",14,1,10,"33770",,"","",,,,,"",,"",,,"",,,"DAVID","wew","10 10
TEST LN","LARGO","FL","33770","X","5","S         ","53.29","499179","","","
       "," / / "," / / ","CHECK
COMING","0.00","te***@test.COM",,"53.29","S","0.00",True,""
{58EEE24C-402C-4C44-B2E1-D055CB10A221},"509401",2006-01-13
12:52:53.173000000,,{2F59D715-99DE-430B-BAAC-FE9752C1A3C7},"C","S","C","","C",,,,,,,,"",,"BETH","wer","11
test ln","",54,1,10,"33709",,"","",,,,,"",,"",,,"",,,"BETH","wer","11 test
ln","SAINT PETERSBURG","FL","33709","C","C","S
","199.00","509401","","","          "," / / "," / / ","C.O.D.
CHECK","0.00","",,"199.00","S","0.00",False,""
=======================

Yes it is large, but that is a temporary thing untill
we totally move into .net 2 techenology from some old dos based system.
I do see ObjectDataSource's DataObjectTypeName to "System.Guid that however
I did not do that the .net 2 wizard did as i said below I am just using the
wizards
to make this happen and it should just work, but does not. I am using
windows sql 2k
if that makes any differance.

Show quoteHide quote

"Steven Cheng[MSFT]" wrote:

> Hi Tdar,
>
> I've just tried the dataset xml and db script you provided, seems the table
> structure is very large which contains lots of columns, I can't quite get
> how to fill some test data. If convenient would you also attache some test
> data to me?
>
> Also ,based on the ASP.NET page's aspx template you provided, I found that
> you set the ObjectDataSource's DataObjectTypeName to "System.Guid", this
> is incorrect since ObjectDataSource.DataObjectTypeName should be configured
> to a type which contains the Properties that can mapped to all the
> parameters in your update, insert methods....
> You can view the description in the MSDN document:
>
> #ObjectDataSource.DataObjectTypeName Property
> http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.objectdat
> asource.dataobjecttypename.aspx
>
> So for your scenario I think the DataObjectTypeName should be configured to
> "DJP_DataSet1.OrderShipRecordRow" ...
>
> You can have a look , if anything unclear, please feel free to post here.
>
> 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: AcYatwcMewVhKBVrRJq376XEWAmeyA==
> | 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>
> | Subject: RE: detailsview,
> | Date: Mon, 16 Jan 2006 08:08:02 -0800
> | Lines: 598
> | Message-ID: <6D608EE7-507F-41F2-9432-5703C2468***@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!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl
> microsoft.public.dotnet.framework.aspnet.webcontrols:32507
> | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webcontrols
> |
> | Hi, as I said i used the wizards, and yes
> | > when try performing
> | > update operation, there raise some exception indicate that the certain
> | > class lack of certain properties... yes?
> |
> | DJP_Dataset1:
> | ====================
> | <?xml version="1.0" encoding="utf-8"?>
> | <xs:schema id="DJP_DataSet1"
> | targetNamespace="http://tempuri.org/DJP_DataSet1.xsd"
> | xmlns:mstns="http://tempuri.org/DJP_DataSet1.xsd"
> | xmlns="http://tempuri.org/DJP_DataSet1.xsd"
> | xmlns:xs="http://www.w3.org/2001/XMLSchema"
> | xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
> | xmlns:msprop="urn:schemas-microsoft-com:xml-msprop"
> | attributeFormDefault="qualified" elementFormDefault="qualified">
> |   <xs:annotation>
> |     <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
> |       <DataSource DefaultConnectionIndex="0"
> | FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout,
> AnsiClass,
> | Class, Public" SchemaSerializationMode="IncludeSchema"
> | xmlns="urn:schemas-microsoft-com:xml-msdatasource">
> |         <Connections>
> |           <Connection AppSettingsObjectName="Web.config"
> | AppSettingsPropertyName="SilverQueen_Main_SystemConnectionString1"
> | ConnectionStringObject="" IsAppSettingsProperty="True"
> Modifier="Assembly"
> | Name="SilverQueen_Main_SystemConnectionString1 (Web.config)"
> | ParameterPrefix="@"
> |
> PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.Con
> nectionStrings.SilverQueen_Main_SystemConnectionString1.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="SilverQueen_Main_SystemConnectionString1 (Web.config)"
> | DbObjectName="SilverQueen_Main_System.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>
> |                 <SelectCommand>
> |                   <DbCommand CommandType="Text" ModifiedByUser="True">
> |                     <CommandText>SELECT     DBMANTransNumber, UserId,
> | ShiptoCompany, ShiptoName, ShipToAddress, ShipToAddress2, ShipCity,
> | ShipCountry, ShipState, ZipCode,
> |                       SignatureReq, ShipKey
> | FROM         OrderShipRecord
> | WHERE     (ShipKey = @ShipKey)</CommandText>
> |                     <Parameters>
> |                       <Parameter AllowDbNull="False"
> | AutogeneratedName="ShipKey" ColumnName="ShipKey"
> | DataSourceName="SilverQueen_Main_System.dbo.OrderShipRecord"
> | DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input"
> | ParameterName="@ShipKey" Precision="0" ProviderType="UniqueIdentifier"
> | Scale="0" Size="16" SourceColumn="ShipKey"
> SourceColumnNullMapping="False"
> | SourceVersion="Current">
> |                       </Parameter>
> |                     </Parameters>
> |                   </DbCommand>
> |                 </SelectCommand>
> |                 <UpdateCommand>
> |                   <DbCommand CommandType="Text" ModifiedByUser="False">
> |                     <CommandText>UPDATE [OrderShipRecord] SET
> | [DBMANTransNumber] = @DBMANTransNumber, [UserId] = @UserId,
> [ShiptoCompany] =
> | @ShiptoCompany, [ShiptoName] = @ShiptoName, [ShipToAddress] =
> @ShipToAddress,
> | [ShipToAddress2] = @ShipToAddress2, [ShipCity] = @ShipCity, [ShipCountry]
> =
> | @ShipCountry, [ShipState] = @ShipState, [ZipCode] = @ZipCode,
> [SignatureReq]
> | = @SignatureReq, [ShipKey] = @ShipKey WHERE (([ShipKey] =
> | @Original_ShipKey))</CommandText>
> |                     <Parameters>
> |                       <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="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="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="@SignatureReq" Precision="0" ProviderType="Bit" Scale="0"
> | Size="0" SourceColumn="SignatureReq" SourceColumnNullMapping="False"
> | SourceVersion="Current">
> |                       </Parameter>
> |                       <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="Guid" Direction="Input"
> | ParameterName="@Original_ShipKey" Precision="0"
> | ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ShipKey"
> | SourceColumnNullMapping="False" SourceVersion="Original">
> |                       </Parameter>
> |                     </Parameters>
> |                   </DbCommand>
> |                 </UpdateCommand>
> |               </DbSource>
> |             </MainSource>
> |             <Mappings>
> |               <Mapping SourceColumn="DBMANTransNumber"
> | DataSetColumn="DBMANTransNumber" />
> |               <Mapping SourceColumn="UserId" DataSetColumn="UserId" />
> |               <Mapping SourceColumn="ShiptoCompany"
> | DataSetColumn="ShiptoCompany" />
> |               <Mapping SourceColumn="ShiptoName"
> DataSetColumn="ShiptoName" />
> |               <Mapping SourceColumn="ShipToAddress"
> | DataSetColumn="ShipToAddress" />
> |               <Mapping SourceColumn="ShipToAddress2"
> | DataSetColumn="ShipToAddress2" />
> |               <Mapping SourceColumn="ShipCity" DataSetColumn="ShipCity" />
> |               <Mapping SourceColumn="ShipCountry"
> | DataSetColumn="ShipCountry" />
> |               <Mapping SourceColumn="ShipState" DataSetColumn="ShipState"
> />
> |               <Mapping SourceColumn="ZipCode" DataSetColumn="ZipCode" />
> |               <Mapping SourceColumn="SignatureReq"
> | DataSetColumn="SignatureReq" />
> |               <Mapping SourceColumn="ShipKey" DataSetColumn="ShipKey" />
> |             </Mappings>
> |             <Sources>
> |             </Sources>
> |           </TableAdapter>
> |         </Tables>
> |         <Sources>
> |         </Sources>
> |       </DataSource>
> |     </xs:appinfo>
> |   </xs:annotation>
> |   <xs:element name="DJP_DataSet1" msdata:IsDataSet="true"
> | msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DJP_DataSet1"
> | msprop:Generator_DataSetName="DJP_DataSet1">
> |     <xs:complexType>
> |       <xs:choice minOccurs="0" maxOccurs="unbounded">
> |         <xs:element name="OrderShipRecord"
> | msprop:Generator_UserTableName="OrderShipRecord"
> | msprop:Generator_RowDeletedName="OrderShipRecordRowDeleted"
> | msprop:Generator_RowChangedName="OrderShipRecordRowChanged"
> | msprop:Generator_RowClassName="OrderShipRecordRow"
> | msprop:Generator_RowChangingName="OrderShipRecordRowChanging"
> | msprop:Generator_RowEvArgName="OrderShipRecordRowChangeEvent"
> | msprop:Generator_RowEvHandlerName="OrderShipRecordRowChangeEventHandler"
> | msprop:Generator_TableClassName="OrderShipRecordDataTable"
> | msprop:Generator_TableVarName="tableOrderShipRecord"

16 Jan 2006 4:09 PM

TdarTdar

and heres the table:
CREATE TABLE [dbo].[OrderShipRecord] (
    [ShipKey] uniqueidentifier ROWGUIDCOL NOT NULL ,
    [DBMANTransNumber] [nvarchar] (10) COLLATE Latin1_General_CI_AS NOT NULL ,
    [CreatedDate] [datetime] NOT NULL ,
    [PackagedDate] [datetime] NULL ,
    [UserId] [uniqueidentifier] NOT NULL ,
    [CarrierCode] [char] (1) COLLATE Latin1_General_CI_AS NULL ,
    [LocationCode] [char] (1) COLLATE Latin1_General_CI_AS NULL ,
    [ShippingServiceID] [char] (1) COLLATE Latin1_General_CI_AS NULL ,
    [ShipInsuranceID] [char] (1) COLLATE Latin1_General_CI_AS NULL ,
    [OrderTypeRWC] [char] (1) COLLATE Latin1_General_CI_AS NULL ,
    [SignatureReq] [bit] NULL ,
    [HighValueFlag] [bit] NULL ,
    [ShipCost] [money] NULL ,
    [OrderTotal] [money] NULL ,
    [ChinaSurcharges] [money] NULL ,
    [CrystalSurcharges] [money] NULL ,
    [OtherSurcharges] [money] NULL ,
    [Order_StaffKeyID] [char] (1) COLLATE Latin1_General_CI_AS NULL ,
    [Paid] [bit] NULL ,
    [ShiptoCompany] [nvarchar] (80) COLLATE Latin1_General_CI_AS NULL ,
    [ShiptoName] [nvarchar] (80) COLLATE Latin1_General_CI_AS NULL ,
    [ShipToAddress] [nvarchar] (80) COLLATE Latin1_General_CI_AS NULL ,
    [ShipToAddress2] [nvarchar] (80) COLLATE Latin1_General_CI_AS NULL ,
    [ShipCity] [int] NULL ,
    [ShipCountry] [int] NULL ,
    [ShipState] [int] NULL ,
    [ZipCode] [nvarchar] (10) COLLATE Latin1_General_CI_AS NULL ,
    [SignRqByPassReport] [bit] NULL ,
    [Final_CarrierCode] [char] (1) COLLATE Latin1_General_CI_AS NULL ,
    [Final_ShippingServiceID] [char] (1) COLLATE Latin1_General_CI_AS NULL ,
    [Final_NumPkgs] [smallint] NULL ,
    [Final_ShipCost] [money] NULL ,
    [Final_DeclaredValue] [money] NULL ,
    [Final_CODAmount] [money] NULL ,
    [Final_Zone] [char] (10) COLLATE Latin1_General_CI_AS NULL ,
    [Final_FreightCharge] [money] NULL ,
    [Final_Weight] [char] (10) COLLATE Latin1_General_CI_AS NULL ,
    [Final_ShipDate] [datetime] NULL ,
    [UPS_ShipCost] [money] NULL ,
    [UPS_Signature] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
    [UPS_Delivered] [bit] NULL ,
    [UPS_DeliveredDate] [datetime] NULL ,
    [Org_Company] [nvarchar] (80) COLLATE Latin1_General_CI_AS NULL ,
    [Org_Name] [nvarchar] (80) COLLATE Latin1_General_CI_AS NULL ,
    [Org_Address] [nvarchar] (80) COLLATE Latin1_General_CI_AS NULL ,
    [Org_City] [nvarchar] (80) COLLATE Latin1_General_CI_AS NULL ,
    [Org_State] [nvarchar] (2) COLLATE Latin1_General_CI_AS NULL ,
    [Org_Zip] [nvarchar] (10) COLLATE Latin1_General_CI_AS NULL ,
    [ORG_DbmanShipmtd] [char] (1) COLLATE Latin1_General_CI_AS NULL ,
    [ORG_dbmanShipMNW] [char] (1) COLLATE Latin1_General_CI_AS NULL ,
    [ORG_DBMANsalesCode] [char] (10) COLLATE Latin1_General_CI_AS NULL ,
    [ORG_2ndODRTot] [nvarchar] (10) COLLATE Latin1_General_CI_AS NULL ,
    [org_shiptran1] [nvarchar] (10) COLLATE Latin1_General_CI_AS NULL ,
    [org_airbill1] [nvarchar] (28) COLLATE Latin1_General_CI_AS NULL ,
    [Org_Airbill2] [nvarchar] (28) COLLATE Latin1_General_CI_AS NULL ,
    [Org_SplitODRStus] [char] (10) COLLATE Latin1_General_CI_AS NULL ,
    [ORG_PakDate] [nvarchar] (10) COLLATE Latin1_General_CI_AS NULL ,
    [ORG_PakDate2] [nvarchar] (10) COLLATE Latin1_General_CI_AS NULL ,
    [DBMAN_STATUS] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
    [DBMANSURCHARGES] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ,
    [EMAIL] [nvarchar] (80) COLLATE Latin1_General_CI_AS NULL ,
    [Breakable] [bit] NULL ,
    [DBMAN_OrderTotal] [nvarchar] (15) COLLATE Latin1_General_CI_AS NULL ,
    [ORG_DEPARTMENT] [char] (1) COLLATE Latin1_General_CI_AS NULL ,
    [ORG_PREMIUMBR] [nvarchar] (10) COLLATE Latin1_General_CI_AS NULL ,
    [CODE] [bit] NULL ,
    [APPRSCDE] [nvarchar] (4) COLLATE Latin1_General_CI_AS NULL
) ON [PRIMARY]
GO

Show quoteHide quote

"Steven Cheng[MSFT]" wrote:

> Hi Tdar,
>
> Welcome to ASPNET newsgroup.
> From your description, you're using a certain TypedDataset(TableAdapter?)
> to return some Data records through datatable and some certain methods for
> update and delete. And you configure the Data Access component through
> ObjectDataSource , it can display data well, however, when try performing
> update operation, there raise some exception indicate that the certain
> class lack of certain properties... yes?
>
> Based on my experience, this is likely caused by the the DataAccess
> component class's Update method's parameters list dosn't match the
> DataBound control's supplied parameters....   As the error message
> indicated:
> =====================
> Could not find a property named 'DBMANTransNumber' on the type specified by
> the DataObjectTypeName property in ObjectDataSource 'ObjectDataSource1'.
> =====================
>
> So you can check the update parameters in the DataBound control (or you can
> use the Updating event to printout all the supplief update parameters...).
> Those parameters will be used by the ObjectDataSource control so as to mapp
> them to each of the parameters in the Update method or properties of the
> Data Object configured in ObjectDataSource (as parameter in the Update
> method...)..
>
> In addition, if convenient, would you post some further detailed code
> snippet and aspx template on the ObjectDataSource, DataBound control and
> the typed dataset so that we can have a look on them?
>
> Thanks,
>
> 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: AcYYg8SbbQRjhNvTTkSewzRImpqrOA==
> | X-WBNR-Posting-Host: 24.73.223.27
> | From: "=?Utf-8?B?VGRhclRkYXI=?=" <Tdar@noemail.nospam>
> | Subject: detailsview,
> | Date: Fri, 13 Jan 2006 12:56:04 -0800
> | Lines: 98
> | Message-ID: <9FAE7DE0-27D3-4015-8BFC-4F83ABC57***@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:32460
> | X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webcontrols
> |
> | Why would i get this error:
> | Could not find a property named 'DBMANTransNumber' on the type specified
> by
> | the DataObjectTypeName property in ObjectDataSource 'ObjectDataSource1'.
> |
> | Here what I am doing, I am using a dataset completly setup by the wizards
> | under the app_code directory, I do a simple "Select * from
> ordershiprecord
> | where ShipKey = @ShipKey" click next, leave fill a datatable, return a
> | datatable, create methods to send updates directly to the
> | database(generateDBDirectMethods) all checked, THen click next again, it
> says
> | it generated select, update, delete, table mappings, fil method, update
> | methods...
> |
> | Then i go to a new web form and drag in a detailsview, choose new
> datasource,
> | object, select the "DJP_DataSet1TableAdpters.OrderShipRecordTableAdapter"
> | that is in the drop down. Click next, look around to see that the
> |
> | select(GetData(Guid ShipKey), returns OrderShipRecordDataTable)
> |
> | update(Update(String DBMANTransNumber, Guid UserId, String ShiptoCompany,
> | String ShiptoName, String ShipToAddress, String ShipToAddress2,
> | Nullable<Int32> ShipCity, Nullable<Int32> ShipCountry, Nullable<Int32>
> | ShipState, String ZipCode, Nullable<Boolean> SignatureReq, Guid ShipKey,
> Guid
> | Original_ShipKey), returns Int32)
> |
> | delete(Delete(Guid Original_ShipKey), returns Int32) method is there
> |
> | Click next
> | it asks to defind Parameters ... QueryString ... Querystringfield =
> ShipKey
> | Click Finish...
> |
> | Page is created
> | Select enable editing and save the page
> |
> | Run the calling page from visual studio...
> | type in shipkey and call the page
> | it shows me the records details just fine
> | so i click Edit to change a value
> | changed Signaturereq and selected Update.
> |
> | I get:
> | ---------------------------------------
> | Could not find a property named 'DBMANTransNumber' on the type specified
> by
> | the DataObjectTypeName property in ObjectDataSource 'ObjectDataSource1'.
> | Description: An unhandled exception occurred during the execution of the
> | current web request. Please review the stack trace for more information
> about
> | the error and where it originated in the code.
> |
> | Exception Details: System.InvalidOperationException: Could not find a
> | property named 'DBMANTransNumber' on the type specified by the
> | DataObjectTypeName property in ObjectDataSource 'ObjectDataSource1'.
> |
> | Source Error:
> |
> | An unhandled exception was generated during the execution of the current
> web
> | request. Information regarding the origin and location of the exception
> can
> | be identified using the exception stack trace below.
> |
> | Stack Trace:
> |
> |
> | [InvalidOperationException: Could not find a property named
> | 'DBMANTransNumber' on the type specified by the DataObjectTypeName
> property
> | in ObjectDataSource 'ObjectDataSource1'.]
> |    System.Web.UI.WebControls.ObjectDataSourceView.BuildDataObject(Type
> | dataObjectType, IDictionary inputParameters) +380
> |
> System.Web.UI.WebControls.ObjectDataSourceView.ExecuteUpdate(IDictionary
> | keys, IDictionary values, IDictionary oldValues) +1512
> |    System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary
> values,
> | IDictionary oldValues, DataSourceViewOperationCallback callback) +179
> |    System.Web.UI.WebControls.DetailsView.HandleUpdate(String commandArg,
> | Boolean causesValidation) +1197
> |    System.Web.UI.WebControls.DetailsView.HandleEvent(EventArgs e, Boolean
> | causesValidation, String validationGroup) +545
> |    System.Web.UI.WebControls.DetailsView.OnBubbleEvent(Object source,
> | EventArgs e) +162
> |    System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
> +56
> |    System.Web.UI.WebControls.DetailsViewRow.OnBubbleEvent(Object source,
> | EventArgs e) +117
> |    System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
> +56
> |    System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +106
> |    System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String
> | eventArgument) +175
> |
> |
> System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.Rai
> sePostBackEvent(String eventArgument) +31
> |    System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> | sourceControl, String eventArgument) +32
> |    System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
> +244
> |    System.Web.UI.
> | -------------------------------------------
> |
> |
> | So why when using the wizards would this happen, how do i solve this and
> | move on....
> |
> | Tdar
> |
> |
> |
> |
>
>