checkbox
-
I want to insert checkbox data into the database if the checkbox is checked. If the checkbox is not checked then don't insert the checkbox data. Mt code isn't working. Here is the code:
myCommand.Parameters.Add("Department", Data.SqlDbType.VarChar).Value = Department myCommand.Parameters.Add("Quality", Data.SqlDbType.VarChar).Value = Quality myCommand.Parameters.Add("Interpersonal", Data.SqlDbType.VarChar).Value = Interpersonal myCommand.Parameters.Add("Timelines", Data.SqlDbType.VarChar).Value = Timelines If CheckBox1.Checked Then myCommand.Parameters.Add("NA", Data.SqlDbType.VarChar).Value = NA End If myCommand.Parameters.Add("Comment", Data.SqlDbType.VarChar).Value = Comment myCommand.Parameters.Add("Domain_Login", Data.SqlDbType.VarChar).Value = UserName myCommand.Connection = myConnection myCommand.ExecuteNonQuery() -
I want to insert checkbox data into the database if the checkbox is checked. If the checkbox is not checked then don't insert the checkbox data. Mt code isn't working. Here is the code:
myCommand.Parameters.Add("Department", Data.SqlDbType.VarChar).Value = Department myCommand.Parameters.Add("Quality", Data.SqlDbType.VarChar).Value = Quality myCommand.Parameters.Add("Interpersonal", Data.SqlDbType.VarChar).Value = Interpersonal myCommand.Parameters.Add("Timelines", Data.SqlDbType.VarChar).Value = Timelines If CheckBox1.Checked Then myCommand.Parameters.Add("NA", Data.SqlDbType.VarChar).Value = NA End If myCommand.Parameters.Add("Comment", Data.SqlDbType.VarChar).Value = Comment myCommand.Parameters.Add("Domain_Login", Data.SqlDbType.VarChar).Value = UserName myCommand.Connection = myConnection myCommand.ExecuteNonQuery()is NA an optional parameter in your proc ? What does 'not working' mean ? Does it blow up ? Does it give an unexpected result ? Does it never work out that checkbox1 is checked ? BTW, for you to put this code in your presentation layer is bad design. I guess the fact that you have a checkbox1 means this is not production code, but still, it's better to form good habits than bad.
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )