Filtering a datatable row using a where clause

Question

I have a DataTable that I am pulling from a DataSet. From the DataTable, I want to use the Where clause to return a particular row. I looked at "How can I select a row from a datatable using two variable values?" but I get an error

"Cannot implicitly convert type 'System.Data.DataRow[]' to 'System.Data.DataRow'"

I searched google, but could not find a solution.

My code is:

mySqlDataAdapter.Fill(myDataSet);

DataTable dtTable = myDataSet.Tables[0];
DataRow dr = dtTable.Select("VendorID = " + Session["VendorId"].ToString());

How can I resolve this?

Steve · Accepted Answer · 2013-07-08T19:59:45.827

The Select method of a DataTable returns an array of DataRow even if your query selects only one row

DataRow[] dr = dtTable.Select("VendorID = " + Session["VendorId"].ToString());

Then, if you really expects just one row, you could easily grab the expected row checking for the length of the array. In this case it is my opinion that no fancy Enumerable extension methods are really needed

if(dr.Length > 0)
{
    string avalue = dr[0]["AColumnName"].ToString();
    ...
}

score 1 · Answer 2 · answered Jul 08 '13 at 19:48

1

Select() is returning an array of rows, and you're assigning it to a single row.

You can do :

DataRow dr = dtTable.Select("VendorID = " + Session["VendorId"].ToString()).First();

or

var dr = dtTable.Select("VendorID = " + Session["VendorId"].ToString());

which will give you an array of rows.

answered Jul 08 '13 at 19:48

Jonesopolis

25,034
12
68
112

Can't find FirstOrDefault in intellisense – Csharp Jul 08 '13 at 19:49
You need .net >= 3.5 and a reference to System.Data.DataSetExtensions and System.Linq for this to work.. – Oscar Jul 08 '13 at 19:51

score 0 · Answer 3 · answered Jul 08 '13 at 19:49

0

Asuming there is only one unique result

DataTable dtTable = myDataSet.Tables[0];
DataRow[] drs = dtTable.Select("VendorID = " + Session["VendorId"].ToString());
if(drs.Length > 0)
    DataRow dr = drs[0];

answered Jul 08 '13 at 19:49

Oscar

13,594
8
47
75

score 0 · Answer 4 · answered Jul 08 '13 at 19:49

DataTable.Select() returns an array of DataRow.

DataRow[] dr = dtTable.Select("VendorID = " + Session["VendorId"].ToString());

If you only want the first record,

DataRow[] dr = dtTable.Select("VendorID = " + Session["VendorId"].ToString()).FirstOrDefault();

score 0 · Answer 5 · answered Jul 08 '13 at 19:50

0

Use the method First():

DataRow dr = dtTable.Select("VendorID = " + Session["VendorId"].ToString()).First();

answered Jul 08 '13 at 19:50

Forte L.

2,772
16
25

score 0 · Answer 6 · answered Jul 08 '13 at 19:50

0

The Select() method returns an IEnumerable collection with one DataRow inside, in your case. You must extract the DataRow from that collection with FirstOrDefault() instead.

answered Jul 08 '13 at 19:50

Harkonnen

791
2
8
21

Filtering a datatable row using a where clause

6 Answers6

Linked