CODEWITHSUNDEEP
c#asp.netgridview
ARATHY
ARATHY

Reputation: 349

how to bind check box values on gridview with the values of database table?

I have a data table column "staff" of type bit. In my grid view i have added an item template of check boxes. I wants o display the check boxes checked if the value of "staff" column =1 on data bind. other wise unchecked.. from searches i have written like this 

<ItemTemplate>
   <asp:CheckBox ID="chk1" runat="server" Checked='<%# bool.Parse(Eval("staff").ToString()) %>'/>      
</ItemTemplate>

 DataSet ds = new DataSet();
 SqlDataAdapter adapter = new SqlDataAdapter("SELECT id,staff FROM staff_details  ", con1);
 adapter.Fill(ds);
 GridView1.DataSource = ds;
 GridView1.DataBind();

but it shows an error "System.FormatException: String was not recognized as a valid Boolean." please help

Upvotes: 6

Views: 42701

Answers (2)

Samiey Mehdi
Samiey Mehdi

Reputation: 9414

ASPX:

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
    <Columns>
        <asp:TemplateField HeaderText="ID">
            <ItemTemplate>
                <asp:Label ID="Label1" runat="server" Text='<%# Eval("id") %>'></asp:Label>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Staff">
            <ItemTemplate>
                <asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Eval("staff") %>' />
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>
<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button" />

Code behind:

protected void Button1_Click(object sender, EventArgs e)
{
    string conStr = @"Data Source=.\SQLEXPRESS;AttachDbFilename=E:\website\w2\App_Data\Database.mdf;Integrated Security=True;User Instance=True";
    SqlConnection con1 = new SqlConnection(conStr);
    con1.Open();
    DataSet ds = new DataSet();
    SqlDataAdapter adapter = new SqlDataAdapter("SELECT id,staff FROM staff_details  ", con1);
    adapter.Fill(ds);
    GridView1.DataSource = ds;
    GridView1.DataBind();
    con1.Close();
}

Upvotes: 4

Ahmed Alaa El-Din
Ahmed Alaa El-Din

Reputation: 1833

Tested and works :

#UPDATE1

Checked='<%#Convert.ToBoolean(Eval("staff")) %>'

<ItemTemplate>
   <asp:CheckBox ID="chk1" runat="server" Checked='<%#Convert.ToBoolean(Eval("staff")) %>' />      
</ItemTemplate>

Upvotes: 5

Related Questions