forum

Home / DeveloperSection / Forums / How to Get a Specific Column Value from a DataTable?

How to Get a Specific Column Value from a DataTable?

Tarun Kumar199324-Feb-2016

I want to fetch a certain column value based on the user input lets say the datatable has two columns ID and CountryName.

I need to find ID in the datatable based on the user input country name.

please help

c# ado.net .net winforms

Updated on 24-Feb-2016

Tarun Kumar

Can you answer this question?

Answer

1 Answers

Uttam Misra

24-Feb-2016

Here you go:

string Name ="MARK";DataTable dt =newDataTable();int ID=(fromDataRow dr in dt.Rowswhere(string)dr["Name"]== Name select(int)dr["ID"]).FirstOrDefault();

forum

How to Get a Specific Column Value from a DataTable?

Tarun Kumar

1 Answers

Liked By