How to select multiple checkbox in gridview and stored those checkbox into databse

Question

1.00/5 (1 vote)

See more:

How to select multiple checkbox in gridview and stored those selected checkbox value into databse...

my design page is:

XML

<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button" />

    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
        Height="298px" Width="593px"
        onselectedindexchanged="GridView1_SelectedIndexChanged"
        onrowdatabound="GridView1_RowDataBound">
        <Columns>
            <asp:BoundField HeaderText="ID" DataField="ID" />
            <asp:BoundField HeaderText="Product Name" DataField="ProductName" />
            <asp:BoundField HeaderText="Price" DataField="price" />
            <asp:BoundField HeaderText="Category" DataField="category" />
            <asp:TemplateField HeaderText="Product">
             <ItemTemplate>
             <asp:Image width="40" Height="40" ImageUrl='<%#Eval("path")%>' runat ="server"  ID="image1" />
             </ItemTemplate>
             </asp:TemplateField>
  <asp:TemplateField HeaderText="Select">
<ItemTemplate>
<asp:CheckBox ID="chkSelect" runat="server" />
</ItemTemplate>
</asp:TemplateField>
        </Columns>
    </asp:GridView>
</asp:Content>

my c# coding is:

C#

protected void Button1_Click(object sender, EventArgs e)
   {



for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox cb =(CheckBox)GridView1.Rows[i].Cells[0].FindControl("chkSelect");//Gets the


if (cb.Checked == true)
{
    
   // how to get those select values and how store those values in database
}
else
{ //Do something here when CheckBox is UnChecked }
}

}
}

Posted 11-Feb-13 17:11pm

Deenuji

Updated 11-Feb-13 19:20pm

v2

Add a Solution

Comments

Nandakishore G N 11-Feb-13 23:48pm

what have done till now? paste it

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Raje_ · Answer 1 · 2013-02-11T19:25:00

Store your selected checkbox value in string:-
I am using Telerik RadGrid, you can modify it by your GridView.

C#

  string strMappedUser = "";
  foreach (GridDataItem gdt in gridUsers.MasterTableView.Items)
  {
      CheckBox chb = (CheckBox)gdt.FindControl("cbSelectUser");
      if (chb.Checked == true)
      {
        if (strMappedUser == "")
           strMappedUser = Convert.ToString(gdt.GetDataKeyValue("UserId"));
        else
           strMappedUser = strMappedUser + "," + Convert.ToString(gdt.GetDataKeyValue("UserId"));
     }
}

Now in Database Use this :-

SQL

CREATE PROCEDURE Sp_Example (
	@aintUserId VARCHAR(500) = ''
	)
AS
BEGIN
	CREATE TABLE #tempTable (
		Id INT
		,UsID VARCHAR(50)
		)

	INSERT INTO #tempTable (
		id
		,UsID
		)
	SELECT Row AS ID
		,Value AS SetValue
	FROM dbo.fn_SplitForOrdering(@aintUserId, ',')

	INSERT INTO t_YourTable (UserId)
	SELECT UsID
	FROM #tempTable

	DROP TABLE #tempTable
END

here is the function used for returning a varchar rowset from a delimited string

SQL

 CREATE FUNCTION dbo.fn_SplitForOrdering (
	@InputText VARCHAR(4000)
	,@Delimiter VARCHAR(10)
	)
RETURNS @Array TABLE (
	Row INT
	,Value VARCHAR(4000)
	)
AS
-----------------------------------------------------------  
-- returns a varchar rowset from a delimited string --  
-----------------------------------------------------------  
BEGIN
	DECLARE @Pos INT
	DECLARE @End INT
	DECLARE @TextLength INT
	DECLARE @DelimLength INT
	DECLARE @Row INT

	SET @TextLength = DataLength(@InputText)

	-- Exit function if no text is passed in  
	IF @TextLength = 0
		RETURN

	SET @Pos = 1
	SET @DelimLength = DataLength(@Delimiter)
	SET @Row = 1

	IF @DelimLength = 0
	BEGIN
		WHILE @Pos <= @TextLength
		BEGIN
			INSERT @Array (
				Row
				,Value
				)
			VALUES (
				@Row
				,SubString(@InputText, @Pos, 1)
				)

			SET @Pos = @Pos + 1
			SET @Row = @Row + 1
		END
	END
	ELSE
	BEGIN
		SET @InputText = @InputText + @Delimiter
		SET @End = CharIndex(@Delimiter, @InputText)

		WHILE @End > 0
		BEGIN
			INSERT @Array (
				Row
				,Value
				)
			VALUES (
				@Row
				,SubString(@InputText, @Pos, @End - @Pos)
				)

			SET @Pos = @End + @DelimLength
			SET @End = CharIndex(@Delimiter, @InputText, @Pos)
			SET @Row = @Row + 1
		END
	END

	RETURN
END

Hope you will get it.
Good luck.