How to Select in Data Table[Answered] RSS

• • Reply
  yogeshweb

  Member

  40 Points

  111 Posts

  How to Select in Data Table

  Apr 17, 2014 05:25 AM|yogeshweb|LINK

  Hi friends,

  I have a data table which i want to filter using between .But I am not able to apply it properly

  Please help.

  I am trying the below code.

  DataTable selectedTable;
  DataRow[] selectRow;
  string fromConcessionaireid;
  string toConcessionaireid;
  
  
  
  selectRow = finalDT.Select(string.Format("CONCESSIONAIREID between '{0}' and '{1}' ", fromConcessionaireid, toConcessionaireid));
  
    

• • Reply
  itsmemuthu

  Contributor

  2801 Points

  708 Posts

  Re: How to Select in Data Table

  Apr 17, 2014 05:42 AM|itsmemuthu|LINK

  You can use a Dataview..

  DataTable selectedTable;
  DataRow[] selectRow;
  string fromConcessionaireid;
  string toConcessionaireid;
  
  DataView dv = new DataView(selectedTable);
  
  dv.RowFilter = string.Format("CONCESSIONAIREID between '{0}' and '{1}' ", fromConcessionaireid, toConcessionaireid);

  Regards,
  
  
  
  Remember To Click On the Post That Helps U
  
• • Reply
  Illeris

  Contributor

  2320 Points

  634 Posts

  Re: How to Select in Data Table

  Apr 18, 2014 10:20 AM|Illeris|LINK

  var query = finalDT.Where(c => !(c.CONCESSIONAIREID >= Convert.ToInt(fromConcessionaireid) && c.CONCESSIONAIREID <= toConcessionaireid));
  var myDataView = query.AsDataView(); // if you want to databind...

  Please remember to click "Mark as Answer" on this post if it helped you
  
  http://illerisblog.wordpress.com/