Loading

How to merge one DataTable to another DataTable in c#?

How to merge one DataTable to another DataTable in c#?

Abhilash J A

Abhilash J A

10y1kVisual Basic .NET

Hello Everyone,

I have two datatable from this query:-

string sql = "SELECT * FROM Tble_UserSetUp inner join Tble_Login on Tble_UserSetUp.Id = Tble_Login.UserId WHERE Tble_Login.UserId='" + Userid + "';select count(*) as docCount from Tble_UserSetUp inner join Tble_Documents on Tble_Documents.UserId = Tble_UserSetUp.Id where Tble_Documents.UserId ='" + Userid + "'";
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
da.Fill(ds);
dt = ds.Tables[0];
dt1 = ds.Tables[1];

dt is getting all userdetails and dt1 is getting only count.

How can I merge dt1 inside dt? There is UserSetUp model class

contain int type countID, how to assign count value to countID variable

from dt1?

public partial class UserSetUp
{
public Int64 countID { get; set; }
}
var userList = from myRow in dt.AsEnumerable()
where myRow.Field<bool>("IsActive1") == true
select myRow;
List objUserSetUp = userList.Select(m => new Model.UserSetUp()
{
Id = m.Field("Id"),
FirstName = m.Field<string>("FirstName"),
SurName = m.Field<string>("SurName"),
Computer_Name = m.Field<string>("Computer_Name"),
IP_Address = m.Field<string>("IP_Address"),
LogInTime = m.Field<string>("LogInTime"),
UserName = Decrypt(m.Field<string>("UserName")),
Password = Decrypt(m.Field<string>("Password")),
login_Id = m.Field("login_Id"),
UserType = "Documents Scanned",
countID = ? /*How can I assign dt1 value inside this variable?*/
}).ToList();

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Midhun Tp10y ago
Accepted answer
Hi,
Please have a look at below threads for some ideas -
http://stackoverflow.com/questions/24020981/linq-query-multiple-datatables-in-dataset
http://stackoverflow.com/questions/2379747/create-combined-datatable-from-two-datatables-joined-with-linq-c-sharp
Ananth G10y ago
Hi Friends,
Here i add code for Merge two datatables.

//Sample DataTable Data for table1
DataTable objDtData1 = new DataTable();
objDtData1.Columns.Add("Column1", typeof(string));
objDtData1.Columns.Add("Column2", typeof(string));
objDtData1.Rows.Add("1", "DataTable1");
//Sample DataTable Data for table1
DataTable objDtData2 = new DataTable();
objDtData2.Columns.Add("Column1", typeof(string));
objDtData2.Columns.Add("Column2", typeof(string));
objDtData2.Rows.Add("2", "DataTable2");
objDtData2.Rows.Add("3", "DataTable3");
This Below part is used to merge two DataTable.
objDtData1.Merge(objDtData2);