How to Get a Specific Column Value from a DataTable?

Tarun Kumar 2482 24 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

Tarun Kumar

Other

1 Answers

Uttam Misra 24 Feb 2016 Accepted Answer

Here you go:

string Name = "MARK";
DataTable dt = new DataTable();
int ID= (from DataRow dr in dt.Rows
              where (string)dr["Name"] == Name
              select (int)dr["ID"]).FirstOrDefault();

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

How to Get a Specific Column Value from a DataTable?

Can you answer this question?

1 Answers