Dataset to database.

[Craig]

Hi I am using a dataset to display my information to a user, however
my dataset is in no way matching all of the fields and columns of my
ms sql database, I fairly extensively modify the data so that the user
can understand it from the raw table.

My question is there some sort of mapping interface that I can use for
these cast and sometimes complete conversions between my dataset table
data and the database. I was hoping there was a more automatic way to
go about it with all the update and insert features of the dataset
then having to write up string sql statements that have the
information.

Is there a better form item to be using? Or any suggestions?

Thank you, Craig.

 

[Nicholas Paldino [.NET/C# MVP]]

Craig,

You might be able to use table mappings in this situation. Check out
the section of the .NET framework documentation titled "Table Mapping in
Data Adapters", located at (watch for line wrap):

http://search.microsoft.com/search/...ble+Mapping+in+Data+Adapters&qa=&qn=&c=10&s=1

Hope this helps.

 

[Nicholas Paldino [.NET/C# MVP]]

Oops, wrong link. Here is the right one:

http://msdn.microsoft.com/library/d...bcon/html/vbcontablemappingindataadapters.asp