How to merge 2 tables fields in DataTable in asp.net
Answer Posted / abc
DataTable dt1 = retDT("select col1,col2 from Table1");
DataTable dt2 = retDT("select col3,col4 from Table2");
dt1.Merge(dt2);
retDT is a funtion to return datatable based on the query.
The output will be like below
if you check the dt1 content then the output will be
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Error : The operation couldn’t be performed because ole db provider sqlncli10 for linked server was unable to begin a distributed transaction.00000110 oledb provider for linked server returned message the partner transaction manager has disabled its support for remote/network transactions. I can able to execute the stored procedure in sql server but when i run the web page getting error like above. I did all the configuration. what is the solution?
Describe the application event handlers in ASP.NET?
What is a web based system?
Define managed code and managed data in .net?
Explain the path instructions in xaml?
How can you pass multiple complex types in Web API?
How does session work in asp net?
Explain the significance of routing? : asp.net mvc
What are the built-in objects in asp.net?
What are the Types of authentications in IIS
what is silver light when will we use silver light,
What is Forms Authentication in ASP.NET?
Explain Life cycle of ASP.NET page when a request is made.
What does passport and windows authentication mean in ASP.NET?
What is full form of asp.net?