duplicate columns into datatable

Hot Topic

v2 calling v1.1
Errors creating new data source
Webresource.axd not downloading over https in ie
MAC Address
recuperer les detail d'un email en utilisant le pop
DateTimePicker in DataGridView
webservice error
Hybrid application: C++, Win32 and WinForms
AddAccessRule doesn't work properly ??
Is it possible to convert XML into a Class?

.NET Development

Can multithreading solve this problem?
Uploading DIME attachments from client to server
need basic help with IRC bot
InternetDial VB 2005 ???
Router's public ip address
output ipconfig result to file
Typed datasets with multiple database vendors (or not)
SQL in Visual Studio 2005
Is there a +/- tree view control wtih more functionality(-Hide+Display controls)
asp remoting

duplicate columns into datatable

Hi,

I have created one DataTable programatically into C#. And I want to add duplicate DataColumns into it i.e. suppose I have one column named "Col1" and I want add one more column with the same name. Its giving "DuplicateNameException".

How should I make it possible. Is there any other way. Please provide some code.

Thank you.

Answer this question

duplicate columns into datatable

  • shoagMSFT

    If suppose that you may want to bind your datatable later to a viewer/Editor like datagrid.

    You could set your viewer/Editor ColumName/Caption to 'show' same 'Name' of column instead of you tying to make it inside datatable.

  • invalid display name

    It is not possible to use the same column name. This is because the accessor for getting data from a cell is to use the columnname <datarow>.Item("Col1"). If there were two of the same it wouldn't know which to grab.

    What are you trying to do that would make you think you need duplicate column names Perhaps you could create multiple datatables instead Or use Col1, Col2 etc.

  • zz1

    Hi Prashant!

    It does'nt make sense at all to have two column in the table with same name therefore its by design that databases doesn't allow duplicate column name in a table. Further more column name tells you what data where, if you have two columns with similar name how would search for data.

    Can tell us the situation where you need duplicate columns, may be someone can you tell better way of doing it.

    Cheers

    Sohail.



  • duplicate columns into datatable
Answer this question