how to insert checkbox values by using stored procedure

Question

hello everyone, I had three checkboxes cb1 cb2 and cb3 , if i check anyone of then and submit then the text in that should be stored in particular column . how to use stored procedure for inserting the checked checkbox value the below is te my table userid happpy angry sad date if i check cb1 and submit the text should be stored in happy same if cb2 is checked then in angry or cb3 then in sad . how to write this in stored procedure . I really got stuck at this . As i am new to this .Someone show me the right directioon. Thanks in Advance.

Cynthia Sathuragiri · Answer

The text of checkbox is taken and store into the table only when it is checked . So i have assigned the checkbox text value to string variables in the name of happy,angry,sad.There you would need to give the checkbox ID name

Cynthia Sathuragiri · Answer

Hi Sindu, Here i am sharing you the code : protected void Submit(object sender, EventArgs e) { string happy = cb1.Checked ? cb1.Text : null; string angry = cb2.Checked ? cb2.Text : null; string sad = cb3.Checked ? cb3.Text : null; string constr = ConfigurationManager.ConnectionStrings["connstring"].ConnectionString; using (SqlConnection con = new SqlConnection(constr)) { using ( SqlCommand cmd = new SqlCommand( "INSERT INTO tbcheck(userid, happy,angry,sad,date) VALUES(@userid, @happy,@angry,@sad,@date)") ) { cmd.Connection = con; cmd.Parameters.AddWithValue("@userid", txtId.Text); cmd.Parameters.AddWithValue("@happy", ((object)happy) ?? DBNull.Value); cmd.Parameters.AddWithValue("@angry", ((object)angry) ?? DBNull.Value); cmd.Parameters.AddWithValue("@sad", ((object)sad) ?? DBNull.Value); cmd.Parameters.AddWithValue("@date", DateTime.Now); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } }

Cynthia Sathuragiri · Answer

Hi Sindu, Can u share me the screenshot of your function where you are getting the exception error. Since the function which i have shared is working perfectly in my local environment

Manav Pandya · Answer

Hello You dont need to check that cb1.checked == true in stored procedure , its completely wrong Do just like that : if cb1 == true begin // your query Thanks

Manav Pandya · Answer

Hello For that you should implement different things i guess like : Make your expression fields like : happy : bit [Datatype] value will be = true / false Its not good to enter text of checkbox If not checked than it will be false Thanks

Cynthia Sathuragiri · Answer

If you give the id of checkbox in the place of object ,the checkbox text will get store into the table if it is unchecked also. But as you said the code needs to store the checkbox value only when it is checked.So i am assigning the checkbox text into another variable only when it is checked else NULL value will be stored . Hope now you get it

Cynthia Sathuragiri · Answer

Just for example i have given the userid as 1. You can use your own functionality to store the value for the column userid (like the logged in user details )

Cynthia Sathuragiri · Answer

Here is the sample code to implement the functionality: Hope it helps!

Manav Pandya · Answer

Hello This is really simple to implement I hope you are getting checkbox text value So thats it pass text to stored procedure as parameter And than go for if condition or switch case , use your text that you got from code Than do insert query as per your requirement Thanks

kalai vanan · Answer

Have you using jquery??

Manav Pandya · Answer

reply with my name so that i can identify you are replying me

Sindhu Kavuri · Answer

hii, after changing it like this i got it cmd.Parameters.AddWithValue("@UserId", txtId.Text); cmd.Parameters.AddWithValue("@happy",happy??(object) DBNull.Value); cmd.Parameters.AddWithValue("@angry", angry ?? (object)DBNull.Value); cmd.Parameters.AddWithValue("@sad", sad ?? (object)DBNull.Value); cmd.Parameters.AddWithValue("@date", DateTime.Now)

Sindhu Kavuri · Answer

hey i amm getting error operator ?? canot be added with the sqlparameters and dbnull

Sindhu Kavuri · Answer

thank you i got it

Sindhu Kavuri · Answer

sorry if i annoy you but i am a newbie to this okay what i got i sholud give id like cb1 in the place of object. is it right or i am not getting what you said . Thank you

Sindhu Kavuri · Answer

and should i have to take text of the checkbox in the place of object.. ?

Sindhu Kavuri · Answer

can you explain me why should i take int userid = 1 , my doubt is if i take int userid = 0 can it take the logged in userid and stores there

Sindhu Kavuri · Answer

can you please show me it as an example because when i write like this if cb1.checked == true BEGIN insert into table name (happy)values (@happy) it is giving me error as cb1 is not in the specified column something like that