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/r...=&qn=&c=10&s=1
Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
-
mvp@spam.guard.caspershouse.com
"Craig" <sailent@hotmail.com> wrote in message
news:35c0cc31.0405070726.1a842ed5@posting.google.c om...[color=blue]
> 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.[/color]
