how to save checked item into database.

amol shelke

hello,
can any one tell me how to insert checked item to a database..i have following code.

protected void ImageButton1_Click(object sender, ImageClickEventArgs e)

SqlConnection con = new SqlConnection(strConnection);

con.Open();

cmd = new SqlCommand("Insert Into UserCreation(FullName,UserName,Email,PhoneNo,RegionID,StateId,CityID,Password,SecurityQue,SecurityAns,MenuMasterID) VALUES(@FullName,@UserName,@Email,@PhoneNo,@RegionID,@StateId,@CityID,@Password,@SecurityQue,@SecurityAns,@MenuMasterID)", con);

cmd.CommandType = CommandType.Text;

cmd.Parameters.AddWithValue("@FullName", txtFullname.Text);

cmd.Parameters.AddWithValue("@UserName", txtUserName.Text);

cmd.Parameters.AddWithValue("@Email", txtEmail.Text);

cmd.Parameters.AddWithValue("@PhoneNo", txtPhoneno.Text);

cmd.Parameters.AddWithValue("@RegionID", DdlRegion.SelectedValue);

cmd.Parameters.AddWithValue("@StateId", DdlState.SelectedValue);

cmd.Parameters.AddWithValue("@CityID", DdlCity.SelectedValue);

cmd.Parameters.AddWithValue("@Password", txtPassword.Text);

cmd.Parameters.AddWithValue("@SecurityQue", txtSecurityquestion.Text);

cmd.Parameters.AddWithValue("@SecurityAns", txtSecurityanswer.Text);

cmd.Parameters.AddWithValue("@MenuMasterID",chkmenuRights.SelectedItem);

cmd.ExecuteNonQuery();

con.Close();

ClientScript.RegisterStartupScript(this.GetType(), "Hello", "alert('Successfully created a user');", true);

txtFullname.Text = "";

txtUserName.Text = "";

txtEmail.Text = "";

txtPhoneno.Text = "";

txtPassword.Text = "";

txtConfirmpassword.Text = "";

txtSecurityquestion.Text = "";

txtSecurityanswer.Text = "";

DdlRegion.SelectedIndex = 0;

DdlState.SelectedIndex = 0;

DdlCity.SelectedIndex = 0;

}

pls help me.
thanx.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

amol shelke14y ago
hello, i want to save checked item in db.for that i made two tables.1)menumasterid in that 2 column menuid and menucaption nd in menu caption all pages name saved like login,newticket,ticket status,knowledgebase. 2)menurights-3column rightid,userid(foreign),menuid(foreign).now i want to insert checked item into user table to add info.to user table i posted above code.so pls tell me how to save checked item in above code. pls help.
Senthilkumar14y ago
Hi,

Satyapriya posted entire code for sample of checkbox.

I think this user facing problem with the checkboxlist.

The checkboxlist can be defined like this.

Width="400px"
Height="100%"
AutoPostBack="false"
runat="server"
CellPadding="2"
CellSpacing="5"
DataTextField="Users"
DataValueField="Users">

If the user selected multiple items then it can be iterated to check which items selected.

protected void btn_returnUserList(object sender, System.Web.UI.ImageClickEventArgs e)
{
for (int i = 0; i < cb_selectUser.Items.Count; i++)
{
if (cb_selectUser.Items[i].Selected)
{

selectedUsers += cb_selectUser.Items[i].Text+",";
}
}

If you have column which can stored by any delimiters (,).
Satyapriya Nayak14y ago
Hi Amol,

Try this...

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="Counter_check_data.WebForm1" %>

    Untitled Page





    Name










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 Counter_check_data
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        SqlCommand com;



        protected void Button1_Click(object sender, EventArgs e)
        {
            if (chk1.Checked == true)
            {
                SqlConnection con = new SqlConnection(strConnString);
                com = new SqlCommand();
                com.Connection = con;
                com.CommandType = CommandType.Text;
                com.CommandText = "insert into login(Name,Category) values(@Name,@Category)";
                com.Parameters.Clear();
                com.Parameters.AddWithValue("@Name", txtName.Text);
                com.Parameters.AddWithValue("@Category", chk1.Text);
                if (con.State == ConnectionState.Closed)
                    con.Open();
                com.ExecuteNonQuery();
                con.Close();
                lblmsg.Text = "Data entered successfully!!!";
                clear();
            }
        }
        void clear()
        {
            txtName.Text = "";
            chk1.Checked = false;

        }
    }
}

Thanks
If this post helps you mark it as answer