Get a boolean value from DataTable

c# .net-1.1
Developer picture Developer · Jun 26, 2009 · Viewed 27.7k times · Source

How do I retrieve a Boolean value in dataset, I'm using visual studio 2003,I am trying the following, but it's not working:

//if product inactive, don't display, and redirect to main page
  if((dbDataSet.Tables["productGeneral"].Rows[0]["Active"].Equals(0)))

I even tried, but not working: 

if((dbDataSet.Tables["productGeneral"].Rows[0]["Active"].toString() == false)

the columns name is ["active"], the value with in column is either True or False, using sql server 2000

please help

Answer

Reed Copsey picture Reed Copsey · Jun 26, 2009

You need to cast to a bool directly, and just check using that.

Have you tried?:

if(((bool)dbDataSet.Tables["productGeneral"].Rows[0]["Active"] == false))

If it's a bool, you'll want to cast the result to a bool directly.

The first fails since 0 is an Int32, not a Boolean. They are not comparable in C#, since they're distinct types. The second fails since ToString() turns the result into a string, and you're comparing a string to a bool, which again will not work.

Related questions

How can I programmatically select an item in a listbox?

I have a listbox displaying items from an enum. I want to select/highlight the current value (read from a database) when the listbox displays/the form opens. This code, though: lblSelectedPrinter.Text = AppSettings.ReadSettingsVal("beltprinter"); listBoxBeltPrinters.SelectedItem = listBoxBeltPrinters.Items.…

Read More
Searching an ArrayList

I'm working on some legacy code, so cannot use Generic List here. I have an ArrayList being returned from a data layer method. Each item in the last consists of an ID and a Description field. I want to loop …

Read More
How to Close a DataReader on Exception

I have the following code in some methods of my Data Layer: StringBuilder sb = new StringBuilder(); SqlCommand s = new SqlCommand(sb.ToString(), conn); try { SqlDataReader dr = s.ExecuteReader(); while(dr.Read()) DoSomething(dr); } catch (Exception ex) { sb.Append(Util.ExceptionRecursive(…

Read More