You might also want to set DataAdapter.MissingSchemaAction to Error. This will alert you to when a new row is found that you do not have mapped instead of blindly adding a new column.
Thanks, Shawn Wildermuth [EMAIL PROTECTED] > -----Original Message----- > From: dotnet discussion [mailto:[EMAIL PROTECTED]] > On Behalf Of Jim Arnold > Sent: Tuesday, May 21, 2002 10:11 AM > To: [EMAIL PROTECTED] > Subject: Re: [DOTNET] How to work around bug in DataSet? > > > It's not a bug. DataSet/DataTable.Clear() removes all > *rows*, but it leaves the schema intact. So after you've > renamed your columns and call Fill() again, new columns will > be created to correspond with the original database schema. > Try using mappings as Bob suggested. > > Jim > > > -----Original Message----- > > From: David Ferguson [mailto:[EMAIL PROTECTED]] > > Sent: 21 May 2002 14:22 > > To: [EMAIL PROTECTED] > > Subject: [DOTNET] How to work around bug in DataSet? > > > > > > How to work around bug in DataSet? > > > > The DataSet wont clear if ColumnNames Modified. > > > > You can read messages from the DOTNET archive, unsubscribe > from DOTNET, or subscribe to other DevelopMentor lists at > http://discuss.develop.com. > You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.