I have a DataTable which contain only one column data1 and many rows. Like abc 123 def 456 ghi Now I want another DataTable with two Columns Name and Number . Like abc 123 def 456 ghi 789 I want data in DataTable two be inserted from DataTable one as above. I have no idea how to do that. Any help please

In Sql Server 2008, You can use merge sql for it. Cheers

Answers

Adding one Datatable data to another

Ghulam Ali

12y

900

1 Active Directory

I have a DataTable which contain only one column data1 and many rows. Like

abc

123

def

456

ghi

Now I want another DataTable with two Columns Name and Number . Like

I want data in DataTable two be inserted from DataTable one as above. I have no idea how to do that. Any help please

Forum Statistics

Please welcome our newest member Zadux Infotech.
2,381,688 users have contributed to 122,515 threads and 389,032
In the past 24 hours, we have 0 new threads, 0 new posts, and 0 new users.
In last week, the most popular thread is 'Testing Forum WYSIWYG Editor Formatting'.

Upcoming Events

View all