Thread: Check checkbox in datagrid

I have this db structure
tblcategorymaster
-Category_Id
-Category_Name

tblitemmaster
-Item_Id
-Category_Id
-Item_Name

tblstoremaster
-Store_Id
-Store_Name.....

tblstoreitemdetails
-Store_Id
-Item_Id

So i now need to show on a page where first store will be selected, then category will be selected and then i will show items on that category in datagrid. I also need to show a checkbox in front of each item, and it will be checked/uncheked if that particular item is present in that store.

So now i first load the datagrid with items in that category.
Then to check the checkboxes, i check in database for that item in that store in datagrid's ItemDataBound event and check if there.

Now my question is can i do it both things in one way/call to db??

VB.NET 2005
MySql 5.0

Thanx

Sure, in the query that populates the datagrid with the category information, have it also return a bit field indicating if the item in present in the store.

I believe you can then bind this field to the checkbox.

Originally Posted by Wolffy

Sure, in the query that populates the datagrid with the category information, have it also return a bit field indicating if the item in present in the store.

I believe you can then bind this field to the checkbox.

Hmm, i was also thinking of that........... let me see if i can write that query

Originally Posted by micky

Hmm, i was also thinking of that........... let me see if i can write that query

Ok, i got it.
Posting my existing working code
added this line in datagrid in .aspx file

Code:

<asp:BoundColumn Visible="False" DataField="bPresent" ReadOnly="True"></asp:BoundColumn>

Then this query to load the datagrid

Code:

Dim strSQL As String = "Select Count(SI.Item_Id) as bPresent, I.Item_Id, I.Item_Name, I.Item_Price From tblitemmaster as I " & _
    "Left Join tblstoreitemdetails as SI on I.Item_Id=SI.Item_Id and SI.Store_Id=@StoreId " & _
    "Where I.Category_Id=@CategoryId Group By I.Item_Id"

Then in datagrid's item data bound event to check the checkbox

Code:

Protected Sub dgItem_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles dgItem.ItemDataBound
    If (e.Item.ItemType = ListItemType.Item) Or (e.Item.ItemType = ListItemType.AlternatingItem) Then
        Dim cb As CheckBox = e.Item.Cells(4).Controls(1)

        Dim intRecord As Integer = e.Item.Cells(5).Text.ToString
        If intRecord = 1 Then
            cb.Checked = True
        Else
            cb.Checked = False
        End If
    End If
End Sub