Merging DataTable Manualy
-
Hi, I am getting more than one Table from different DataBase and manualy marging into one table. this procedure taking more time.so i need to improve performance. if i use DataTable.Merge method it's merging.it's add new row in same table. can one help me Thanks
-
Hi, I am getting more than one Table from different DataBase and manualy marging into one table. this procedure taking more time.so i need to improve performance. if i use DataTable.Merge method it's merging.it's add new row in same table. can one help me Thanks
Why are you merging them? What is the eventual goal?
-
Why are you merging them? What is the eventual goal?
becuase database not on same machine so i can not put join in stored procedure.so what i am doing.get all data from all database and merge then creating dataview on merged data and fillter it. thanks
-
becuase database not on same machine so i can not put join in stored procedure.so what i am doing.get all data from all database and merge then creating dataview on merged data and fillter it. thanks
If they are both SQL Server you can link the servers. Otherwise, yeah, you'll need to do it manually. I've never done that, but it sounds like an interesting challenge.