Choose specific column from datatable and compare the value to string

Question

Basically I want to know how to select a specific column by calling its name and compare its row value to a string/int.

This is my datatable https://i.stack.imgur.com/LgYVd.png

Something like this: iterate through particular column in a datatable

        adp.Fill(ds); //Fill Dataset
        dt = ds.Tables[0]; //Then assign table to dt


        foreach (DataRow row in dt.Rows)
        {


        }

Plenty of answers here https://stackoverflow.com/questions/13760072/select-certain-columns-of-a-data-table — Syntax Error, Feb 07 '19 at 10:33
if it's really an `int` i'd use `bool isMyPort = row.Field("Master_Port") == yourPort`. One advantage, it supports nullables, so if this column can contain `DbNull`s you can write: `int? port = row.Field("Master_Port")` — Tim Schmelter, Feb 07 '19 at 10:35

score 0 · Answer 1 · answered Feb 07 '19 at 10:40

0

You can use the column name to get the value as like below

int Value;
bool IsInteger;

foreach (DataRow row in dt.Rows)
{  
IsInteger = int.TryParse(row["columnname"].ToString(), out Value);

if(!IsInteger)
{
}
}

answered Feb 07 '19 at 10:40

Mohan Kittusamy

87
6

Is there a compact way to do that with 3 different colums? – Jake Mogensen Feb 07 '19 at 11:46

score 0 · Answer 2 · answered Feb 07 '19 at 11:05

0

I'd suggest you to use DataRow.Field extension method from System.Data.DataSetExtensions package, its a generic method that does type conversion for you, also takes in column as DataColumn, column index or string column name.

foreach (DataRow dataRow in dataTable.Rows)
{
    dataRow.Field<string>("mycolumn");
}

answered Feb 07 '19 at 11:05

Ram Kumaran

621
6
12

How do i add an if/else to that? – Jake Mogensen Feb 07 '19 at 12:36
I have a feeling this is what you're looking for https://stackoverflow.com/a/13701216/1343192 – Ram Kumaran Feb 07 '19 at 12:55

Choose specific column from datatable and compare the value to string

2 Answers2