I have a database which requires the field authorized to be set when inserting. How do I set the default value of that to false for all new reviews created?

Please rephrase your question, right now the answer is:

You either write you SQL query to set the value for you on insert or you set the default value of the column to 0.

hth.
-Doug

__________________
===============================================
Doug Parsons
Wrox online library: Wrox Books 24 x 7
Did someone here help you? Click on their post!
"Easy is the path to wisdom for those not blinded by themselves."
===============================================

The table that I want to insert information to is called Review and here are the fields and where I would like to get the information from:

ID - Primary Key, automatically generated
Name - Get this from the aspnetProfile table based on logged in user
Email Address - Get this from the aspnetMembership table based on logged in user
Review - User entered information
Authorized - Default value set to False
CityId - Value of dropdown list on the page
UserId - Get this from the aspnetMembership table based on logged in user

Is it possible to select this information and then bind it to the fields in the table, I am using a DataView?