asked on
How do I get multiple column values from data table.
Hi guys,
I have Person table and
dt has this table values.
DataTable dt = getPersonTable();
![Person table]()
I want to have FirstName and LastName for PersonId = 4 from DataTable, dt.
How can I accomplish this?
I have Person table and
dt has this table values.
DataTable dt = getPersonTable();
I want to have FirstName and LastName for PersonId = 4 from DataTable, dt.
How can I accomplish this?
C#ASP.NET.NET Programming
Last Comment
zephyr_hex (Megan)
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Here is how I would approach it:
or, if you just want the First and Last name, you can do:
//select record(s) to data rows
DataRow[] childRow = dt.Select("PersonId = 4");
//if at least one record is found
if(childRow.Any())
{
//copy rows to a datatable
DataTable childDt = childRows.CopyToDataTable();
}
or, if you just want the First and Last name, you can do:
var test = from row in dt.AsEnumerable()
where row.Field<int>("PersonId") == 4
select new {First = row.Field<string>("FirstName"), Last = row.Field<string>("LastName")};
something like
PersonID = dt.Rows(0).Columns(0)
LastName = dt.Rows(0).Columns(1)
....