I am a newbie here. I am trying to write a SQL statement in ASP.NET to do an insert into a table on MS SQL Server. My dilemma is that all of the fields in the table are ints and on the web form, they are all check boxes. How can I set this up. The username comes from a session.
strSQL = "INSERT INTO tblPurpose(username, check1, check2, check3, "
strSQL += "check4, check5, check6) VALUES('"
where do i go from here?