asp .net checkbox inside gridview checked

Question

I have a main 'Products' table and a 'Products_Recommended' table. I want the users to be able to select several products from a GridView using checkboxes and then insert those Product IDs (prodid) into the Products_Recommended table in such a way that a main Product ID is entered (coming from query string) and potentially several recommended ProdIDs get entered. So far so good. But I need to be able to show the checkboxes to be checked if there were already prodids in the Products_Recommended table previously. The code below show a 'sqldatasource1' which gets the data from the Products_Recommended table based on query string. I just don't know how the checkboxes can get checked because the GridView has a different sqldatasource binding it. Thanks! Meengla

  <form id="form1" runat="server">
<asp:GridView ID="Products" runat="server" AutoGenerateColumns="False" DataKeyNames="prodid"
    DataSourceID="alldata" EnableModelValidation="True">
    <Columns>
        <asp:TemplateField>
            <ItemTemplate>
                <asp:CheckBox ID="ProductSelector" runat="server" />
            </ItemTemplate>
        </asp:TemplateField>
        <asp:BoundField  DataField="itemnumber" HeaderText="Item Number" SortExpression="itemnumber" />

        <asp:BoundField DataField="itemtitle" HeaderText="itemtitle" SortExpression="itemtitle" />
    </Columns>
</asp:GridView>
<p>
    <asp:Button ID="SelectedProducts" runat="server" Text="Recommend" OnClick="SelectedProducts_Click" />
</p>
<p>
    <asp:Label ID="lblProdSelected" runat="server" EnableViewState="False" Visible="False"></asp:Label>
</p>
<asp:SqlDataSource ID="alldata" runat="server" ConnectionString="<%$ ConnectionStrings:dbconnection %>"
    SelectCommand="SELECT * FROM Products">
    <SelectParameters>
        <asp:QueryStringParameter DefaultValue="14" Name="itemid" QueryStringField="itemid"
            Type="Int32" />
    </SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:dbconnection %>"
    SelectCommand="SELECT * FROM dbo.products_recommended WHERE prodid = @itemid)">
    <SelectParameters>
        <asp:QueryStringParameter DefaultValue="14" Name="itemid" QueryStringField="itemid"
            Type="Int32" />
    </SelectParameters>
</asp:SqlDataSource>

VMAtm · Accepted Answer · 2011-07-05 20:58:39Z

1

Handle the RowDataBound event, and in the method find the checkbox and set its Checked value.

<asp:GridView ID="Products" OnRowDataBound="GridViewRowEventHandler">

void CustomersGridView_RowDataBound(Object sender, GridViewRowEventArgs e)
{
  if(e.Row.RowType == DataControlRowType.DataRow)
  {
    var ProductSelector = e.Row.FindControl("ProductSelector") as CheckBox;
    ProductSelector.Checked = true;
  }
}

You can use the Select method of DataSource to retrieve the data you need

edited Jul 5, 2011 at 20:58

answered Jul 5, 2011 at 20:44

VMAtm

28.4k17 gold badges85 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

IrfanClemson Over a year ago

Okay. Let me try your solution. Thanks!

IrfanClemson Over a year ago

Hi, but the Gridview itself is bound to sqldatasource with id 'alldata' while the checkboxes need to be populated or not based on the values from the sqldatasource with id of 'SqlDataSource1'. So your solution will not work?

VMAtm Over a year ago

@Meengla You can use the Select method of DataSource to retrieve the data you need

IrfanClemson Over a year ago

but how? I have been stuck half a day so if easy to point out then please do so.

VMAtm Over a year ago

You should read the documentation about this method, and you didn't provide any info about rules for the checking/unchecking your checkboxes

|

Collectives™ on Stack Overflow

asp .net checkbox inside gridview checked

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related