Hi,

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

Thank you,
Alan

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
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

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



Show quoteHide quote

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
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

View Excel Document in VB.Net Form
ADO.net Code contest
(C#/2.0) ORA-01036 Error When Upd/Ins/Del from Gridview
TableAdapter Garbage
adapter.fill and progress bar