Insert Value From CheckBox in Database (MySQL) in asp.net using C#

can you help plz .....i m having two dropdownlists which are used for 1st foe time in hr and other used for time in min but i want that both value should come in one column only for getting hh:mm like that


for eg...    01:30 PM

help plz

Thanks its working ...thanks for help

Hi Dhanashri,


Try this...



<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Insert_multiple_Value_CheckBoxList._Default" %>





 


 

 

 
 
  a
  b
  c
 
 
 

 
 

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

namespace Insert_multiple_Value_CheckBoxList

{

    public partial class _Default : System.Web.UI.Page

    {

        string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

        SqlCommand com;

 

        protected void Button1_Click(object sender, EventArgs e)

        {

            SqlConnection con = new SqlConnection(connStr);

            string s1 = string.Empty;

            foreach (ListItem item in this.CheckBoxList1.Items)

            {

                if (item.Selected)

                {

                    s1 = item.ToString();

                    com = new SqlCommand("Insert into test values('" + s1 + "')", con);

                    con.Open();

                    int iCount = com.ExecuteNonQuery();

                    con.Close();

                }

            }

 

        }

    }

}

 

Thanks
If this post helps you mark it as answer

Thanks for helping me ...but by this code the group of data is stored in database i want that checked data should be store in one column row wise means


it stores a,b,c  ....i don't want this

i want it should take as

eg.
column- Name
  a
 b
 c


can you help me for it.....

Hi Dhanashri,


Try this...



<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Insert_multiple_Value_CheckBoxList._Default" %>





 


 

 

 
 
  a
  b
  c
 
 
 

 
 






using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace Insert_multiple_Value_CheckBoxList
{
  public partial class _Default : System.Web.UI.Page
  {
  string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
  SqlCommand com;

  protected void Button1_Click(object sender, EventArgs e)
  {
  SqlConnection con = new SqlConnection(connStr);
  string s1 = string.Empty;
  foreach (ListItem item in this.CheckBoxList1.Items)
  {
  if (item.Selected)
  {
  s1 += item + ",";
  }
  }

  com = new SqlCommand("Insert into test values('" + s1 + "')", con);
  con.Open();
  int iCount = com.ExecuteNonQuery();
  con.Close();
  }
  }
}






Thanks
If this post helps you mark it as answer