Mapping in ADO.NET 2 Dataset Designer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

A.M-SG - 12 Jan 2006 18:21 GMT

Hi,

Where is the mapping designer in VS2005 DataSet designer? I cannot find it!

Thank you,
Alan

Reply to this Message

Kevin Yu [MSFT] - 13 Jan 2006 02:25 GMT

Hi Alan,

What do you mean by mapping? Do you mean the column mapping? If so, you
just need to change the column name in the TableAdapter and the mapping
code will be generated automatically.

Kevin Yu

Signature

=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Reply to this Message

A.M-SG - 13 Jan 2006 17:55 GMT

Yes I mean column mapping.

Your solution wroks for DataTables that are generated from a database query
(TableAdapter)

My question is related to DataSets that are not attached to any database
objects. You just drag and drop a data set from tool box within dataset
designer. There is no mapping available for them.

Thank you for help,
Alan

> Hi Alan,
>
[quoted text clipped - 6 lines]
> "This posting is provided "AS IS" with no warranties, and confers no
> rights."

Reply to this Message

Kevin Yu [MSFT] - 16 Jan 2006 04:46 GMT

Hi Alan,

If you designed the DataSet in the DataSet designer, you will always need a
DataAdapter to fill data. The column mapping is a part of the DataAdapter,
not DataSet.

So when you drag and drop a DataAdapter onto the designer, you will find a
TableMappings property in the property window. Click on the three dots and
you'll see a dialog box. Then you can set the TableMappings and
ColumnMappings for each table. HTH.

Kevin Yu

Signature

=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Reply to this Message

Mapping in ADO.NET 2 Dataset Designer

Free Magazines