Reputation: 181
I want to show Checkbox in Gridview,
But now, it only show dynamic data in Gridview,
Didn't show dynamic checkbox in Gridview.
How can I fix problem, thanks.
.aspx.cs
protected void Page_Load(object sender, EventArgs e)
{
using (var conn = new SqlConnection(strConn))
{
try
{
conn.Open();
ckloginConnectionString.SelectCommand = @"select a,b,c,d ,e from testTable where a =@a ";
ckloginConnectionString.SelectParameters.Add("a", a);
//==================
DataView dv = (DataView)ckloginConnectionString.Select(new DataSourceSelectArguments());
GridView1.DataSource = dv;
GridView1.DataBind();
//==================
ckloginConnectionString.DataBind();
ckloginConnectionString.DataBind();
}
catch (Exception ex)
{
ex.ToString();
}
}
}
.aspx
<div class="table-wrapper">
<asp:GridView runat="server" ID="GridView1" CssClass="alt" DataKeyNames="InsertedDate,Upload_Schoo_No" AutoGenerateColumns="False" OnRowCommand="grvclscour_RowCommand">
<Columns>
<asp:TemplateField HeaderText="check" InsertVisible="false" ItemStyle-BorderStyle="Double">
<ItemTemplate>
<asp:CheckBox ID="CheckBox1" runat="server" Visible="true" />
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="a" HeaderText="a">
<ItemStyle HorizontalAlign="Center" />
</asp:BoundField>
<asp:BoundField DataField="b" HeaderText="b">
<ItemStyle HorizontalAlign="Center" />
</asp:BoundField>
<asp:BoundField DataField="c" HeaderText="c">
<ItemStyle HorizontalAlign="Center" />
</asp:BoundField>
<asp:ButtonField CommandName="d" HeaderText="d">
<ItemStyle HorizontalAlign="Center" />
</asp:ButtonField>
<asp:ButtonField CommandName="e" HeaderText="e">
<ItemStyle HorizontalAlign="Center" />
</asp:ButtonField>
</Columns>
</asp:GridView>
</div>
Upvotes: 2
Views: 1930
Reputation: 1285
Eval
would do what you want i guess.
change your grid desing like this:
<asp:GridView runat="server" ID="GridView1" CssClass="alt" DataKeyNames="InsertedDate,Upload_Schoo_No" AutoGenerateColumns="False" OnRowCommand="grvclscour_RowCommand">
<Columns>
<asp:TemplateField HeaderText="check" InsertVisible="false" ItemStyle-BorderStyle="Double">
<ItemTemplate>
<asp:CheckBox ID="CheckBox1" runat="server" Visible="true" Checked='<%# Eval("YourDataField") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="a" HeaderText="a">
<ItemStyle HorizontalAlign="Center" />
</asp:BoundField>
<asp:BoundField DataField="b" HeaderText="b">
<ItemStyle HorizontalAlign="Center" />
</asp:BoundField>
<asp:BoundField DataField="c" HeaderText="c">
<ItemStyle HorizontalAlign="Center" />
</asp:BoundField>
<asp:ButtonField CommandName="d" HeaderText="d">
<ItemStyle HorizontalAlign="Center" />
</asp:ButtonField>
<asp:ButtonField CommandName="e" HeaderText="e">
<ItemStyle HorizontalAlign="Center" />
</asp:ButtonField>
</Columns>
</asp:GridView>
Upvotes: 3