SQL Query to get a boolean value from a BIT type column

Question

I am facing a problem getting the boolean value from one of the columns of my database. I am using SQL Server 2008 where in I have created a databaseas follows:

Table name: SysUser3 and columns as:

ProductName || ProductId || SelectedProducts

The column SelectedProducts is a BIT type column and contains False values for each of the row entries at present.

Now, I am writing a SQL Query to get the boolean value from my 'SelectedProducts' column

Here is my code:

    using (SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|Database.mdf;User Instance=true"))
        {
            con.Open();

            string cmdString = "SELECT ProductName,SelectedProducts FROM SysUser3";
            using (SqlCommand cmd = new SqlCommand(cmdString, con))
            {
                using (SqlDataReader dataRead = cmd.ExecuteReader())
                {
                    while (dataRead.Read())
                    {
                        items.Add(new ProductModel
                        {
                            Selected=(bool)dataRead["SelectedProducts"];
                            ProductName= dataRead["ProductName"].ToString()
                        });
                    }
                }
            }
        }

I am getting an error at this line and hence not able to run the code:

Selected=(bool)dataRead["SelectedProducts"];

Am I doing it correctly ? can someone tell me what's wrong in the code?

The error message suggests that there are "syntax errors" on that very line that I have mentioned above plus the following line of ProductName=.... — Parth Doshi
– Parth Doshi, Commented Dec 24, 2011 at 5:07

Nick VanderPyle · Accepted Answer · 2011-12-24 05:14:58Z

3

You have a semicolon misplaced. Change it to a comma. It should read:

                while (dataRead.Read())
                {
                    items.Add(new ProductModel()
                    {
                        Selected=(bool)dataRead["SelectedProducts"],
                        ProductName= dataRead["ProductName"].ToString()
                    });
                }

answered Dec 24, 2011 at 5:14

Nick VanderPyle

2,9993 gold badges27 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

KV Prajapati · Accepted Answer · 2011-12-24 05:09:37Z

3

You may try GetBoolean(column_odrinal) method.

  if(!dataRead.IsDBNull(1))
     Selected=dataRead.GetBoolean(1);

OR you may fix it if return value if null.

Selected =  (dataRead["SelectedProducts"] as bool?) ??  false ;

edited Dec 24, 2011 at 5:09

answered Dec 24, 2011 at 4:56

KV Prajapati

94.8k20 gold badges151 silver badges188 bronze badges

1 Comment

Nick VanderPyle Over a year ago

In this case, you know the ordinal position of the column is 1, but if you wanted to get it by column name, use GetOrdinal(). msdn.microsoft.com/en-us/library/…

Collectives™ on Stack Overflow

SQL Query to get a boolean value from a BIT type column

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related