Simple GridView Problem

[Tina]

I'm trying to do something very straightforward in a 2.0 asp.net app with a
GridView - ObjectDataSourc e - DataSet.

I create a DataSet that accesses the NorthWind Customers Table - all columns
and I choose to generate all methods and updates. I connect this DataSet to
an ObjectDataSourc e and connect my DataView to the ObjectDataSourc e. (I did
not opt for optimistic concurrency) It displays just fine. Then I try to
change an address field in a row and get the error pasted below. The update
command that was generated is also pasted below. This is stuff right out of
textbooks. What is wrong?

Thanks,
T

ObjectDataSourc e 'ods2' could not find a non-generic method 'Update' that
has parameters: CompanyName, ContactName, ContactTitle, Address, City,
Region, PostalCode, Country, Phone, Fax, original_Custom erID.
UPDATE Customers
SET CustomerID = @CustomerID, CompanyName = @CompanyName,
ContactName = @ContactName, ContactTitle = @ContactTitle, Address =
@Address,
City = @City, Region = @Region, PostalCode =
@PostalCode, Country = @Country, Phone = @Phone, Fax = @Fax
WHERE (CustomerID = @Original_Custo merID)

[Ron]

"Tina" <Ti**********@n ospamexcite.com wrote in message
news:ek******** ********@TK2MSF TNGP03.phx.gbl. ..

I'm trying to do something very straightforward in a 2.0 asp.net app with
a GridView - ObjectDataSourc e - DataSet.

I create a DataSet that accesses the NorthWind Customers Table - all
columns and I choose to generate all methods and updates. I connect this
DataSet to an ObjectDataSourc e and connect my DataView to the
ObjectDataSourc e. (I did not opt for optimistic concurrency) It displays
just fine. Then I try to change an address field in a row and get the
error pasted below. The update command that was generated is also pasted
below. This is stuff right out of textbooks. What is wrong?

Thanks,
T

ObjectDataSourc e 'ods2' could not find a non-generic method 'Update' that
has parameters: CompanyName, ContactName, ContactTitle, Address, City,
Region, PostalCode, Country, Phone, Fax, original_Custom erID.
UPDATE Customers
SET CustomerID = @CustomerID, CompanyName = @CompanyName,
ContactName = @ContactName, ContactTitle = @ContactTitle, Address =
@Address,
City = @City, Region = @Region, PostalCode =
@PostalCode, Country = @Country, Phone = @Phone, Fax = @Fax
WHERE (CustomerID = @Original_Custo merID)

Hi Tina.
The problem could be caused by an incorrect setting in your
ObjectDataSourc e.Have you made sure the ObjectDataSourc e is configured not
to send original values together with your own parameters?
The ObjectDataSourc e OldValuesParame terFormatString property should not be
set if you want to send only your own parameters.
HTH
Ron.

[Tina]

OldValuesParame terFormatString was set to Original_{0} so I set it to blank
and the same thing happens.
T

"Ron" <no***@nowhere. comwrote in message
news:ea******** ******@TK2MSFTN GP02.phx.gbl...

"Tina" <Ti**********@n ospamexcite.com wrote in message
news:ek******** ********@TK2MSF TNGP03.phx.gbl. ..

>I'm trying to do something very straightforward in a 2.0 asp.net app with
a GridView - ObjectDataSourc e - DataSet.

I create a DataSet that accesses the NorthWind Customers Table - all
columns and I choose to generate all methods and updates. I connect this
DataSet to an ObjectDataSourc e and connect my DataView to the
ObjectDataSour ce. (I did not opt for optimistic concurrency) It displays
just fine. Then I try to change an address field in a row and get the
error pasted below. The update command that was generated is also pasted
below. This is stuff right out of textbooks. What is wrong?

Thanks,
T

ObjectDataSour ce 'ods2' could not find a non-generic method 'Update' that
has parameters: CompanyName, ContactName, ContactTitle, Address, City,
Region, PostalCode, Country, Phone, Fax, original_Custom erID.
UPDATE Customers
SET CustomerID = @CustomerID, CompanyName = @CompanyName,
ContactName = @ContactName, ContactTitle = @ContactTitle, Address =
@Address,
City = @City, Region = @Region, PostalCode =
@PostalCode, Country = @Country, Phone = @Phone, Fax = @Fax
WHERE (CustomerID = @Original_Custo merID)

Hi Tina.
The problem could be caused by an incorrect setting in your
ObjectDataSourc e.Have you made sure the ObjectDataSourc e is configured not
to send original values together with your own parameters?
The ObjectDataSourc e OldValuesParame terFormatString property should not be
set if you want to send only your own parameters.
HTH
Ron.

[Ron]

"Tina" <Ti**********@n ospamexcite.com wrote in message
news:%2******** ********@TK2MSF TNGP05.phx.gbl. ..

OldValuesParame terFormatString was set to Original_{0} so I set it to
blank and the same thing happens.
T

<snip>
OK, Tina.
Try removing the CustomerID = @CustomerID from your parameter list.
I wonder why you are using an ObjectDataSourc e and a DataSet when normally
an SqlDataSource works directly with a GridView. I set up an SqlDataSource
and a GridView to view and update the Northwind Customer Table without any
problem, but the Update SQL code in the SqlDataSource did not include a
CustomerID = @CustomerID, because CustomerID is the primary key of the
Customer table. So try changing your Update code to

UPDATE Customers
SET CompanyName = @CompanyName, ContactName = @ContactName,
ContactTitle = @ContactTitle, Address = @Address, City = @City, Region =
@Region, PostalCode = @PostalCode, Country = @Country, Phone = @Phone, Fax =
@Fax
WHERE (CustomerID = @Original_Custo merID)

You may have to change the WHERE clause to

WHERE (CustomerID = @CustomerID)

If that does not fix the problem, I suggest using an SqlDataSource instead
of the ObjectDataSourc e.

HTH

Ron.