How to bind the numeric value in DB with Checkbox in gridview

Question

0.00/5 (No votes)

See more:

Hi,..

i have a page in that i have one gridview like below

XML

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
                <Columns>
                    <asp:TemplateField HeaderText="Master">
                        <EditItemTemplate>
                            <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
                        </EditItemTemplate>
                        <ItemTemplate>
                            <asp:Label ID="Label1" runat="server" Text='<%#Eval("Master") %>' />
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="Can Add">
                        <EditItemTemplate>
                            <asp:CheckBox ID="CheckBox1" runat="server" />
                        </EditItemTemplate>
                        <ItemTemplate>
                            <asp:CheckBox ID="CheckBox1" runat="server" />
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="Can Update">
                        <EditItemTemplate>
                            <asp:CheckBox ID="CheckBox2" runat="server" />
                        </EditItemTemplate>
                        <ItemTemplate>
                            <asp:CheckBox ID="CheckBox2" runat="server" />
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="User Level">
                        <EditItemTemplate>
                            <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
                        </EditItemTemplate>
                        <ItemTemplate>
                            <asp:Label ID="Label2" runat="server" ></asp:Label>
                        </ItemTemplate>
                    </asp:TemplateField>
                </Columns>
                <EmptyDataTemplate>
                    Master
                </EmptyDataTemplate>
            </asp:GridView>

by using this gridvew me stored data in DB using the following C# Code

C#

protected void Button2_Click(object sender, EventArgs e)
    {
        con.Open();

        kk = GridView1.Rows.Count;

        string HH = "select count(*) from Tbl_Com_UserRights where userlevel='" + DDUserLvl.Text + "'";

        cmd = new SqlCommand(HH, con);

        reccont = (Int32)cmd.ExecuteScalar();

        if (reccont == 0)
        {
            for (int i = 0; i < kk; i++)
            {
                mas = ((Label)(GridView1.Rows[i].Cells[0].FindControl("Label1"))).Text;

                if (((CheckBox)(GridView1.Rows[i].Cells[0].FindControl("CheckBox1"))).Checked == true)
                {
                    aa = 1;
                }
                else
                {
                    aa = 0;
                }
                if (((CheckBox)(GridView1.Rows[i].Cells[0].FindControl("CheckBox2"))).Checked == true)
                {
                    bb = 1;
                }
                else
                {
                    bb = 0;
                }

                level = Convert.ToDouble( DDUserLvl.Text);

                if (mas == "" && aa == 0 && bb == 0)
                {
                    return;
                }
                else
                {
                    cmd = new SqlCommand("insert into Tbl_Com_UserRights(master,canadd,canupdate,userlevel) values('" + mas + "','" + aa + "','" + bb + "','" + level + "')", con);

                    Int32 CC = (Int32)cmd.ExecuteNonQuery();
                }
            }
        }
        con.Close();
    }

now these values stored in DB correctly
as like

Master_Name ,0 (or) 1, 0 (or)1 ,User_Level(1,2..)

now my question is how to retrieve these DB containing Data in Same Gridview
or another gridview...

in that if 2nd & 3rd column value is 0 or 1,...
if the value is 1 Checkbox in gridview Shouldbe Checked
else the value is 0 Checkbox Shouldnot be Checked...

How is This Possible?
How To combine (or Bind)that numeric value with Chechbox in Gridview

Please Provide Me the C# Code To Retrieve and also the Template field Source...

Thanks in Advance....

Posted 19-Aug-12 22:27pm

Raajendran

Updated 20-Aug-12 0:34am

v2

Add a Solution

3 solutions

Solution 1

see below code you will get some idea

XML

<asp:templatefield headertext="Can Update" xmlns:asp="#unknown">
                       <edititemtemplate>
                           <asp:checkbox id="CheckBox2" runat="server" checked='<%#Convert.ToBoolean(Eval("yourcolumnname"))' />
                       </edititemtemplate>
                       <itemtemplate>
                           <asp:checkbox id="CheckBox2" runat="server" checked='<%#Convert.ToBoolean(Eval("yourcolumnname"))' />                        </itemtemplate>
                   </asp:templatefield>

Posted 19-Aug-12 22:35pm

Sangramsingh Pawar

Updated 19-Aug-12 22:37pm

v2

Comments

Raajendran 20-Aug-12 6:31am

Thanks for this information dude...

its getting error because of that xmlns part in that code u provided

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)

_Amy · Accepted Answer · 2012-08-20T00:41:00

Solution 2

Make sure that the value 0 and 1 is coming as BIT from database. You need to bind it in front-end like this:

ASP.NET

<itemtemplate>
    <asp:checkbox id="CheckBox1" runat="server" checked='<%#Eval("ChkColumn1")%>' />
</itemtemplate>

And if your data(0 and 1) is not coming as BIT then CASTE it in sqlserver itself. Use this:

SQL

SELECT CAST(ChkColumn1 AS BIT) FROM table1

--Amit

Posted 20-Aug-12 0:41am

_Amy

Updated 20-Aug-12 21:31pm

v4

Comments

Raajendran 20-Aug-12 6:49am

Thnak u dude..

In Sql Its gives the ErrorMessageg Like this for my below Query

SELECT CASTE(Canadd) BIT FROM Tbl_Com_UserRights

_Amy 20-Aug-12 6:53am

Try my updated answer. Little mistake was there.

Raajendran 21-Aug-12 3:19am

Hi Dude.. Thank u... that your Updated Query executing...

_Amy 21-Aug-12 3:30am

If it is working then accept as a solution so that others can find the solution easily.. :)

__TR__ 21-Aug-12 3:37am

My 5!

Raajendran · Accepted Answer · 2012-08-21T00:06:00

Hi Friends... Thank u So Much to all...

in my aspx page me add another one gridview like below

XML

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
        Width="100%">
        <Columns>
            <asp:TemplateField HeaderText="Master">
                <EditItemTemplate>
                    <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
                </EditItemTemplate>
                <ItemTemplate>
                    <asp:Label ID="Label1" runat="server" Text='<%#Eval("Master") %>' />
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Can Add">
                <EditItemTemplate>
                    <asp:CheckBox ID="CheckBox1" runat="server" />
                </EditItemTemplate>
                <ItemTemplate>
                    <asp:CheckBox ID="CheckBox1" runat="server" />
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Can Update">
                <EditItemTemplate>
                    <asp:CheckBox ID="CheckBox2" runat="server" />
                </EditItemTemplate>
                <ItemTemplate>
                    <asp:CheckBox ID="CheckBox2" runat="server" />
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="User Level">
                <EditItemTemplate>
                    <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
                </EditItemTemplate>
                <ItemTemplate>
                    <asp:Label ID="Label2" runat="server"></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>

    </asp:GridView>
    <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" Width="100%">
        <Columns>
            <asp:TemplateField HeaderText="Master">
                <EditItemTemplate>
                    <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
                </EditItemTemplate>
                <ItemTemplate>
                    <asp:Label ID="Label1" runat="server" Text='<%#Eval("Master") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Can Add">
                <EditItemTemplate>
                    <asp:CheckBox ID="CheckBox1" runat="server" />
                </EditItemTemplate>
                <ItemTemplate>
                    <asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Eval("CanAdd").ToString() == "1" ? true : false %>' />
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Can Update">
                <EditItemTemplate>
                    <asp:CheckBox ID="CheckBox2" runat="server" />
                </EditItemTemplate>
                <ItemTemplate>
                    <asp:CheckBox ID="CheckBox2" runat="server" Checked='<%# Eval("CanUpdate").ToString() == "1" ? true : false %>' />
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="User Level">
                <EditItemTemplate>
                    <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
                </EditItemTemplate>
                <ItemTemplate>
                    <asp:Label ID="Label2" runat="server" Text='<%#Eval("UserLevel") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>
    </asp:GridView>

in my aspx.cs page i wrote the below code

C#

protected void Button2_Click(object sender, EventArgs e)
    {
        con.Open();
        
        kk = GridView1.Rows.Count;

        string HH = "select count(*) from Tbl_Com_UserRights where userlevel='" + DDUserLvl.Text + "'";

        cmd = new SqlCommand(HH, con);

        reccont = (Int32)cmd.ExecuteScalar();

        if (reccont == 0)
        {
            for (int i = 0; i < kk; i++)
            {
                mas = ((Label)(GridView1.Rows[i].Cells[0].FindControl("Label1"))).Text;

                if (((CheckBox)(GridView1.Rows[i].Cells[0].FindControl("CheckBox1"))).Checked == true)
                {
                    aa = 1;
                }
                else
                {
                    aa = 0;
                }
                if (((CheckBox)(GridView1.Rows[i].Cells[0].FindControl("CheckBox2"))).Checked == true)
                {
                    bb = 1;
                }
                else
                {
                    bb = 0;
                }

                if (bb == 1)
                {
                    aa = 1;
                }

                level = Convert.ToDouble(DDUserLvl.Text);

                if (mas == "" && aa == 0 && bb == 0)
                {
                    return;
                }
                else
                {
                    cmd = new SqlCommand("insert into Tbl_Com_UserRights(master,canadd,canupdate,userlevel) values('" + mas + "','" + aa + "','" + bb + "','" + level + "')", con);

                    Int32 CC = (Int32)cmd.ExecuteNonQuery();
                }
            }
        }
        else
        {
            Int32 KK = GridView2.Rows.Count;

            for (int i = 0; i < KK; i++)
            {
                mas = ((Label)(GridView2.Rows[i].Cells[0].FindControl("Label1"))).Text;

                if (((CheckBox)(GridView2.Rows[i].Cells[0].FindControl("CheckBox1"))).Checked == true)
                {
                    aa = 1;
                }
                else
                {
                    aa = 0;
                }
                if (((CheckBox)(GridView2.Rows[i].Cells[0].FindControl("CheckBox2"))).Checked == true)
                {
                    bb = 1;
                }
                else
                {
                    bb = 0;
                }

                level = Convert.ToDouble(DDUserLvl.Text);

                if (mas == "" && aa == 0 && bb == 0)
                {
                    return;
                }
                else
                {
                    cmd = new SqlCommand("Update  Tbl_Com_UserRights Set canadd='" + aa + "',canupdate='" + bb + "' WHERE master='" + mas + "' and userlevel='" + level + "'", con);

                    Int32 CC = (Int32)cmd.ExecuteNonQuery();
                }
            }
        }
        DDUserLvl.Text = "Select Level";
        if (kk != 0)
        {
            ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('Configration Saved');", true);
        }
        else
        {
            ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('Configration Updated');", true);
        }
        Btn_Save.Text = "Save";
        GridView2.DataSource = null;
        GridView2.DataBind();
        GridView1.DataSource = null;
        GridView1.DataBind();
        con.Close();
    }