Search value with datatable select in specific row range

Nebula

7y19.6k

Hi, I am trying to get value from specific row range.

This is the code i tried but not sure where should i use the variable rows.

var rows = dt.AsEnumerable().Skip(0).Take(15);
string value = "CB123";
DataRow[] result = dt.Select("BOOKCODE like '%" + value + "%'");
//foreach (var col in rows)
//{
if (result.Count() > 0)
{
MessageBox.Show("BookCode Not Found");
//Application.Exit();
}
//}

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bryian Tan7y ago
Nebula

"Does this line iterate the row start from 2nd row until row 5?"

Yes. In the example, the code is retrieving a set of records from row between 2 and 5.
Manoj Bhoir7y ago
Hi,

Try this.
var rows = dt.AsEnumerable().Skip(0).Take(15).CopyToDataTable();
            string value = "CB123";
            DataRow[] result = rows.Select("BOOKCODE like '%" + value + "%'");
            //foreach (var col in rows)
            //{
            if (result.Count() > 0)
            {
                MessageBox.Show("BookCode Not Found");
                //Application.Exit();
            }
Rajanikant Hawaldar7y ago
Hi Nebula,

use this code

var rows = dt.AsEnumerable()
.Where((row, index) => index >= 2 && 15 <= index)
.CopyToDataTable();
string value = "CB123";
DataRow[] result = rows.Select("BOOKCODE like '%" + value + "%'");
if (result.Count() > 0)
{
MessageBox.Show("BookCode Not Found");
}
Rajanikant Hawaldar7y ago
Hi Nebula, I am outside now, go through briyan code put 15 instead of 5
Nebula7y ago
Hi Brian

Does this line iterate the row start from 2nd row until row 5?

.Where((row, index) => index >= 2 && 5 >= index)
Nebula7y ago
Hi Rajanikant,

I receive this error

System.InvalidCastException: 'Unable to cast object of type 'd__25`1[System.Data.DataRow]' to type 'System.Data.DataTable'.'

at line DataTable rows = (DataTable)dt.AsEnumerable().Skip(0).Take(15);
Bryian Tan7y ago
here is an example
void Test()
{
DataTable table = new DataTable();
table.Columns.Add("Dosage", typeof(int));
table.Columns.Add("Drug", typeof(string));
table.Columns.Add("Patient", typeof(string));
table.Columns.Add("Date", typeof(DateTime));

    // Here we add five DataRows.
table.Rows.Add(25, "Indocin", "David", DateTime.Now);
table.Rows.Add(50, "Enebrel", "Sam", DateTime.Now);

table.Rows.Add(10, "Hydralazine", "Christoff", DateTime.Now);
table.Rows.Add(21, "Combivent", "Janet", DateTime.Now);
table.Rows.Add(100, "Dilantin", "Melanie", DateTime.Now);
table.Rows.Add(22, "xx", "dd", DateTime.Now);

table.Rows.Add(777, "Dilantin 2", "cc", DateTime.Now);

    //this should return 10,21,100,22
var resultRange = table.AsEnumerable()
.Where((row, index) => index >= 2 && 5 >= index)
.CopyToDataTable();

    //this should return 100
var value = "di";
var result = resultRange.Select("Drug like '%" + value + "%'");
}
Reference: https://stackoverflow.com/questions/12930840/how-to-select-rows-from-datatable-based-on-index-row-number
Rajanikant Hawaldar7y ago
Hi Nebula,

Refer this code

DataTable rows = (DataTable)dt.AsEnumerable().Skip(0).Take(15);
string value = "CB123";
DataRow[] result = rows.Select("BOOKCODE like '%" + value + "%'");
if (result.Count() > 0)
{
//MessageBox.Show("BookCode Not Found");
}

https://www.c-sharpcorner.com/article/dataview-in-C-Sharp/