How do I ...

Results 1 to 2 of 2

Thread: How do I ...

  1. #1
    Join Date
    Dec 1969

    Default How do I ...

    Hello to all, <BR><BR>I have an Access table with several rows in it and a boolean field (column) that only has one row (record) that is TRUE. <BR><BR>Using C# how do I programmatically determine the row that is TRUE and get the index of that row? <BR><BR>So far I am at: <BR>foreach (DataRow row in ds.Tables["currlist"].Rows <BR><BR>I would assume this will go through each row and then find the row that is TRUE in the boolean field. If there is a different, better way please point me in the right direction. <BR><BR>Thanks, <BR>BIll Antonacchio <BR>

  2. #2
    Join Date
    Dec 1969

    Default The *much* better way.... to use SQL to only *get* one row in the first place.<BR><BR>Is there a reason that you need to get all the rows and then do this outside the DB???<BR><BR>If you must have all the rows, the you might want to look at the SELECT method:<BR><BR><BR><B R>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts