FillSchema and AddWithKey Don't Operate As Promised?

My blog has moved.
You can view this post at the following address:
http://www.osherove.com/blog/2003/6/29/fillschema-and-addwithkey-dont-operate-as-promised.html
Published Sunday, June 29, 2003 8:42 PM by RoyOsherove
Filed under:

Comments

Sunday, June 29, 2003 4:42 PM by TrackBack

# ISerializable

ISerializable
Sunday, June 29, 2003 4:42 PM by TrackBack

# ISerializable

ISerializable
Tuesday, July 01, 2003 2:26 AM by Yaron ben shalom

# re: FillSchema and AddWithKey Don't Operate As Promised?

Just to affirm your recent update, here is an excerpt from http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q313483:

The DataAdapter does not have any information about the database that it is reading from and writing to; the DataAdapter only runs the commands that it manages. Therefore, the DataAdapter does not create DataRelation objects in the DataSet. To create DataRelation objects in the DataSet, you must use one of the following methods:
Create the objects programmatically at run time.
Load the schema from an XML Schema Definition (XSD) file.
Build the objects into the design-time DataSet schema.
Tuesday, July 01, 2003 2:28 AM by Roy Osherove

# re: FillSchema and AddWithKey Don't Operate As Promised?

Yaron: Yeah. I found that out the hard way. Take a look here for my solution:
http://weblogs.asp.net/rosherove/posts/9542.aspx