checkbox in the gridview

Question

0.00/5 (No votes)

See more:

I have a table which contains userid,productid,permission . Userid and productid are inserted from a page and permission is getting false automatically since default value is false . Now i want to show the userid ,productid and permission in a grid view and if admin wants it will check and make true the permission .

I take a checkbox on the page for that and on rowdatabound when checkbox.checked ! = null then i inserted true and take that value in session . And then update in the table on the button click but checking the check box not working .

Posted 4-Oct-11 23:24pm

Vimalrashamra

Add a Solution

Comments

Muralikrishna8811 5-Oct-11 8:33am

post your code

4 solutions

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)

Muralikrishna8811 · Answer 1 · 2011-10-05T03:26:00

Hi,

check this once

HTML

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <script src="Scripts/jquery-1.4.1-vsdoc.js" type="text/javascript"></script>
    <script src="Scripts/jquery-1.4.1.js" type="text/javascript"></script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:datalist id="DataList1" runat="server" width="337px" xmlns:asp="#unknown">
            <HeaderTemplate>
                <table width="100%" align="center">
                    <tr>
                        <td>
                            User ID
                        </td>
                        <td>
                            Product ID
                        </td>
                        <td>
                            Permission
                        </td>
                    </tr>
            </HeaderTemplate>
            <itemtemplate>
                <tr>
                    <td>
                        <asp:label id="Lbluid" runat="server" text="<%#Eval("userid") %>"></asp:label>
                    </td>
                    <td>
                        <asp:label id="Lblpid" runat="server" text="<%#Eval("proid") %>"></asp:label>
                    </td>
                    <td>
                        <asp:checkbox id="CheckBox1" runat="server" />
                    </td>
                </tr>
            </itemtemplate>
            <footertemplate>
                </footertemplate></table>
            
        </asp:datalist>
        <br />
        <asp:button id="Button1" runat="server" text="Button" onclick="Button1_Click" xmlns:asp="#unknown" />
    </div>
    </form>
</body>
</html>

And code behind file contains

C#

DataTable dt = new DataTable();
protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        filldata();
    }
}
public void filldata()
{

    dt.Columns.Add("userid");
    dt.Columns.Add("proid");
    addrowin("1", "123");
    addrowin("2", "324");
    addrowin("5", "67");
    addrowin("7", "87");
    addrowin("9", "23");
    DataList1.DataSource = dt;
    DataList1.DataBind();
}
public void addrowin(string uid,string pid)
{
    DataRow dr = dt.NewRow();
    dr[0] = uid;
    dr[1] = pid;
    dt.Rows.Add(dr);
}

protected void Button1_Click(object sender, EventArgs e)
{
    foreach (DataListItem dti in DataList1.Items)
    {
        string qry="";
        string uid = ((Label)dti.FindControl("Lbluid")).Text;
        string pid = ((Label)dti.FindControl("Lblpid")).Text;
        CheckBox chper=(CheckBox )dti.FindControl ("CheckBox1");
        if(chper .Checked )
        {
            qry = "insert into PermissionTab values ("+uid +","+pid+",'True'";
        }
        else
        {
            qry = "insert into PermissionTab values (" + uid + "," + pid + ",'False'";
        }
    }
}

Now tell me is it correct or not

All the Best

puneetisonfire89 · Answer 2 · 2011-10-05T00:41:00

Solution 4

<asp:TemplateField HeaderText="Amount">
<ItemTemplate>
<asp:Label runat="server" ID="Amt"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
Use different type of control according to the requirment ...Fine

Posted 5-Oct-11 0:41am

puneetisonfire89

Comments

Vimalrashamra 5-Oct-11 6:48am

Its working by BoundField also and actually its not showing data because i did not add DataField Property . Anyways Thanks

puneetisonfire89 · Answer 3 · 2011-10-05T00:38:00

Solution 3

use template field to add controls in grid

Posted 5-Oct-11 0:38am

puneetisonfire89

Comments

Vimalrashamra 5-Oct-11 6:43am

doing same for check box and i dont want to change the adminid and itemid

Muralikrishna8811 · Answer 4 · 2011-10-04T23:42:00

Solution 1

Hi,

Here I write some code for checking checkbox in data controls

ASP.NET

<asp:datalist id="DataList1" runat="server" width="70%" onitemcommand="DataList1_ItemCommand" xmlns:asp="#unknown">
          <HeaderTemplate>
              <table width="100%" align="center" border="1">
          </HeaderTemplate>
          <itemtemplate>
              <tr>
                  <td>
                      <asp:checkbox id="CheckBox1" runat="server" />
                  </td>
                  <td>
                      <asp:linkbutton id="LinkButton1" commandname="changepremi" commandargument="<%#Eval("Userid")" runat="server">change</asp:linkbutton>
                  </td>
              </tr>
          </itemtemplate>
          <footertemplate>
              </footertemplate></table>

      </asp:datalist>

And code behind file contains following code

C#

protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
    if (e.CommandName == "changepremi")
    {
        string id = e.CommandArgument.ToString();
        CheckBox chbox = (CheckBox)e.Item.FindControl("CheckBox1");
        if (chbox.Checked)
        {
            // update database
        }
        else
        {
            //update database
        }
    }
}

I hope my guess is right in your question .We cannot raise data control event with checkbox in data control except selectedchange event.

All the Best

Posted 4-Oct-11 23:42pm

Muralikrishna8811

Comments

Vimalrashamra 5-Oct-11 5:52am

You are right sir, But i want that on the place of update database , the checkbox value will be true and then i store it in the session . And when user clicks on the submit button then it will be inserted . Because if user checked and then unchecked it its value is already inserted in the database

Muralikrishna8811 5-Oct-11 5:56am

can you post your design code

Vimalrashamra 5-Oct-11 6:49am

Thanks Murli for help . Its working fine now .

Vimalrashamra 5-Oct-11 6:54am

but a problem still occurs when i check any checkbox its take all the checkbox as checked

Muralikrishna8811 5-Oct-11 6:57am

check your data filling method must be in
if(!ispostback)
{
//fill data
}

Vimalrashamra 5-Oct-11 7:09am

On checking only one row it makes the whole column true .
Actually i have to do it for a row

Muralikrishna8811 5-Oct-11 6:47am

make sure your control ids are correct

place break point on page load and trace where you got that error

Vimalrashamra 5-Oct-11 7:19am

when i check only one row and makes its entry in table then it makes whole rows value true .

Muralikrishna8811 5-Oct-11 8:19am

post your code plz

without your code we can not figure out your problem

Vimalrashamra 5-Oct-11 8:55am

<%@ Page Language="C#" MasterPageFile="~/admin/Admin.master" AutoEventWireup="true" CodeFile="ProductPermission.aspx.cs" Inherits="Admin_ProductPermission" %>
<%@ Import Namespace="Softex.Utilities" %>
<asp:Content ContentPlaceHolderID="HeadContent" ID="PageHeadContent" runat="server">

<asp:Content ContentPlaceHolderID="PageContent" ID="PageMainContent" runat="server">
<div class="PageContent">
<table cellpadding="0" cellspacing="0" style="width: 100%" align="center">
<tr>
<td>
Grant Product Permission .
</td>
</tr>
<tr>
<td style="height: 10px">

</td>
</tr>
<tr>
<td>
<asp:GridView ID="ProductGridView" runat="server" Height="10px" Width="650px" DataKeyNames="userpermissionid"
OnRowDataBound="ProductDetail_DataBound" CellPadding="4" ForeColor="#333333" GridLines="None"
BorderColor="#A1A5D9" BorderStyle="Solid" BorderWidth="1px" CellSpacing="1"
BackColor="#A1A5D9" AutoGenerateColumns="False" >
<rowstyle backcolor="#F7F6F3" forecolor="#333333">

<columns>
<asp:BoundField HeaderText="Admin Id" DataField="adminuserid"
ControlStyle-CssClass="cssWidth" >
<controlstyle cssclass="cssWidth">

<asp:BoundField HeaderText="ProductId" DataField="productid"
ControlStyle-CssClass="cssWidth" >

<controlstyle cssclass="cssWidth">

<asp:TemplateField HeaderText="Permission" ItemStyle-HorizontalAlign="Center">
<itemtemplate>
<asp:CheckBox runat="server" ID="chkSelect" />

<footerstyle backcolor="#5D7B9D" font-bold="True" forecolor="White">
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<editrowstyle backcolor="#999999">
<alternatingrowstyle backcolor="White" forecolor="#284775">

<asp:Button ID="EditButton" runat="server" Text="Edit" OnClick="ButtonEdit_Click" />
</td></tr></table></div>

using System;
using System.Data;
using System.Web.UI.WebControls;
using MySql.Data.MySqlClient;

public partial class Admin_ProductPermission : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

if (!IsPostBack)
{
BindProductData();

}
}
private void BindProductData()
{
DataManager myData = new DataManager(DbFunctions.GetConnectionString());
MySqlConnection myPConn = myData.GetPooledConnection(new MySqlConnection());
string sWhere = null;
sWhere = "permissionstatus <> " + TextUtilities.ToSql("true", "S");
// LabelError.InnerText = "";

DataSet permissionTable = myData.GetDataSetValues("userpermission", "*", sWhere, null, null, "ProductGridView", myPConn);

if (permissionTable.Tables["ProductGridView"].Rows.Count == 0)
{

// Products.DataSource = null;
//LabelError.InnerText

checkbox in the gridview

4 solutions

Solution 5

Solution 4

Solution 3

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us