c# how to update checkbox in database through SQL Query

i am trying to update the checked state of a collom in my database.

below is the code i have but i am unsure of how to implement the checkbox. Thank you for any help.

                con.Open();
                OleDbCommand cmd = new OleDbCommand(String.Concat("Select * From ", comboBox1.Text), con);
                cmd.CommandType = CommandType.Text;
                string tableName = comboBox1.Text.ToString();
                cmd.CommandText = "UPDATE [" + tableName + "] SET People_Call_Status = '" + Status_textBox1.Text 
                    + "', Research_Date = '" + Date_textBox.Text
                    + "', Company_Name = '" + company_NameTextBox.Text
                    + "', tblCompanies_Area_Dialling_Code = '" + tblCompanies_Area_Dialling_CodeTextBox.Text
                    + "', Work_Number = '" + work_NumberTextBox.Text
                    + "', building_Address = '" + building_AddressTextBox.Text
                    + "', [Street Address] = '" + street_AddressTextBox.Text
                    + "', suburb = '" + suburbTextBox.Text
                    + "', city = '" + cityTextBox.Text
                    + "', res_Code = '" + res_CodeTextBox.Text
                    + "', industry_Vertical_ID = '" + industry_Vertical_IDTextBox.Text
                    + "', pO_Box = '" + pO_BoxTextBox.Text
                    + "', post_Office = '" + post_OfficeTextBox.Text
                    + "', postal_Code = '" + postal_CodeTextBox.Text
                    + "', country_ID = '" + country_IDTextBox.Text
                    + "', province_ID = '" + province_IDTextBox.Text
                    + "', prospect = '" + prospectCheckBox.Checked //not working

                    + "'  WHERE Company_ID = " + company_IDTextBox.Text + ";";




                cmd.ExecuteNonQuery();
                {
                    MessageBox.Show("Update Success!");
                    con.Close();
                }