how to insert multiple checkbox data into database

So much of code duplication. Avoid it as any cost, please. Even if this is a home / casual prototype project.

 

Please consolidate all your database access code at SINGLE place. Use OO features. DO NOT put database access code in your UI classes.

Hello

 

Its really simple to detect

 

Problem is that :

 

You are either passion more value than table have numbers of column

 

Or You are passing less value than required

 

Check twiche the code  

 

Thank 

String strConnString =

ConfigurationManager.ConnectionStrings["sqlcon"].ConnectionString;

SqlCommand com;

protected void Page_Load(object sender, EventArgs e)

{

}

protected void Button1_Click(object sender, EventArgs e)

{

if(cb1.Checked==true)

{

SqlConnection con = new SqlConnection(strConnString);

com = new SqlCommand();

com.Connection = con;

com.CommandType = CommandType.Text;

com.CommandText = "insert into tblmood values(@mood)";

com.Parameters.Clear();

com.Parameters.AddWithValue("@mood", cb1.Text);

if (con.State == ConnectionState.Closed)

con.Open();

com.ExecuteNonQuery();

con.Close();

lblDisplay.Text = "Entered Successfully...!!";

}

else if (cb2.Checked == true)

{

SqlConnection con = new SqlConnection(strConnString);

com = new SqlCommand();

com.Connection = con;

com.CommandType = CommandType.Text;

com.CommandText = "insert into tblmood values(@mood)";

com.Parameters.Clear();

com.Parameters.AddWithValue("@mood", cb2.Text);

if (con.State == ConnectionState.Closed)

con.Open();

com.ExecuteNonQuery();

con.Close();

lblDisplay.Text = "Entered Successfully...!!";

}

else

{

SqlConnection con = new SqlConnection(strConnString);

com = new SqlCommand();

com.Connection = con;

com.CommandType = CommandType.Text;

com.CommandText = "insert into tblmood values(@mood)";

com.Parameters.Clear();

com.Parameters.AddWithValue("@mood", cb3.Text);

if (con.State == ConnectionState.Closed)

con.Open();

com.ExecuteNonQuery();

con.Close();

lblDisplay.Text = "Entered Successfully...!!";

}

}

}

}

I am using htis code for this but getting the error , can you help what is tis error and how to solve this.

 

MY ERROR IS 

 

Hello

 

Well you can do this in different ways like :

 

- Stroring option with comma sepearated 

 

- Storing Only checked checkbox values 

 

etc ...

 

For complete reference you can go through some article :

 

https://www.aspsnippets.com/Articles/Save-Insert-multiple-CheckBoxes-CheckBoxList-values-to-database-in-ASPNet-MVC.aspx

 

https://www.aspsnippets.com/Articles/Insert-multiple-values-from-CheckBoxList-to-Database-in-ASPNet.aspx

 

http://www.neerajcodesolutions.com/2014/12/how-to-insert-multiple-checkboxlist.html 

 

Forum answer for same question :

 

http://www.c-sharpcorner.com/forums/how-to-save-multiple-checkbox-values-in-database-in-c-sharp

 

I hope your doubt will be solved 

 

Thanks 

Hi Sindhu Kavuri,

 

You can get all your selected checkbox value using jquery below is the link for reference and then you can use ajax POST method to send your data to your method second link has an example of that. Please refer the links and if you get any problem then let  me know.

 

1) http://www.aspdotnet-suresh.com/2014/03/jquery-get-all-checked-checkbox-values.html

 

2)https://www.aspsnippets.com/Articles/Call-ASPNet-Page-Method-using-jQuery-AJAX-Example.aspx

 

Thanks.