How to insert multiple check check box value in database

Pankaj Kumar

12y4.6k.NET

Module	Select
Home	Add Delete Updated View
Abouts	Add Delete Updated View
Career	Add Delete Updated View
Contact	Add Delete Updated View

Tail me friend how to insert multiple check checkbox value insert into database above fig databse have two field Module And Select how to insert selected colum Add Delete Updated View those are check is insert into database how my code is

Asp Code

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Home.aspx.cs" Inherits="Home" %>

<%--

--%>

Code Behind

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Data.SqlClient;

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

{

SqlConnection con = new SqlConnection("Data Source=GANGESH-PC;Initial Catalog=ISB;User ID=sa;Password=sasa");

protected void Page_Load(object sender, EventArgs e)

{

string str = "select Module from Modules";

SqlCommand cmd = new SqlCommand(str,con);

SqlDataAdapter sda = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

sda.Fill(ds);

GridView1.DataSource = ds;

GridView1.DataBind();

}

protected void Button1_Click(object sender, EventArgs e)

{

string str = string.Empty;

string strname = string.Empty;

foreach (GridViewRow gvrow in GridView1.Rows)

{

CheckBox chk = (CheckBox)gvrow.FindControl("chkSelect");

if (chk != null & chk.Checked)

{

str += GridView1.DataKeys[gvrow.RowIndex].Value.ToString() + ',';

strname += gvrow.Cells[2].Text + ',';

}

4 Replies

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

Vithal Wadje12y ago
Refer my article,might you will get some hint

http://www.c-sharpcorner.com/UploadFile/0c1bb2/insert-bulk-records-into-database-using-Asp-Net-C-Sharp/
Jaganathan Bantheswaran12y ago
Thats why you have module id in the module action. Whenever an action is done on the module, you can update the modified actions with the moduleactions table based on the moduleid right.
Pankaj Kumar12y ago
But my requerment is such type module name is seperated than action=Seleted is seperated each module performing action insert into database
Jaganathan Bantheswaran12y ago
Hi,

You have to redesign your DB so that your DB has a new Table called "ModuleActions" where you store moduleID, and add, delete, update and delete as a boolean columns.

While saving the table values insert the checked values with module id.