Search value with datatable select in specific row range

Question

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(); } //}

Bryian Tan · Answer

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

Bryian Tan · Answer

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 Bhoir · Answer

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 Hawaldar · Answer

Hi Nebula, use this code var rows = dt.AsEnumerable() .Where((row, index) => index >= 2 && 15 .CopyToDataTable(); string value = "CB123"; DataRow[] result = rows.Select("BOOKCODE like '%" + value + "%'"); if (result.Count() > 0) { MessageBox.Show("BookCode Not Found"); }

Rajanikant Hawaldar · Answer

Hi Nebula, I am outside now, go through briyan code put 15 instead of 5

Nebula · Answer

Hi Brian Does this line iterate the row start from 2nd row until row 5? .Where((row, index) => index >= 2 && 5 >= index)

Nebula · Answer

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);

Rajanikant Hawaldar · Answer

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/