Mapping in ADO.NET 2 Dataset Designer

  • Thread starter Thread starter A.M-SG
  • Start date Start date
A

A.M-SG

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
 
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."
 
Back
Top