i have this gridview, i want their checkbox checked if their posi no is in the database on page load
My code
INSERT [dbo].[issuesheet] ([id], [pid], [machine], [orderquantity], [workdocket], [cylinders], [dies], [embossings], [inks], [ints], [comment], [solvents]) VALUES (1, 206, N'machine', 67543, N'bbbbb', N'[''150057680-1A'',''150057680-4A'',''150057680-3A'']', N'[]', N'[]', N'[]', NULL, NULL, N'[]')
--from the table i have three(3) cylinders available
N'[''150057680-1A'',''150057680-4A'',''150057680-3A'']
<asp:GridView ID="avDetails" runat="server" AutoGenerateColumns="False"
Font-Names="Candara"
Font-Size="8px" DataKeyNames="pid"
Width="100%" Style="margin-bottom: 0px"
CssClass="grid" CellPadding="2" ForeColor="#333333" GridLines="None" Font-Bold="True">
<AlternatingRowStyle BackColor="White" />
<Columns>
<asp:BoundField DataField="no" HeaderText="BASE NO" />
<asp:BoundField DataField="Pid" HeaderText="PROD CODE" />
<asp:BoundField DataField="posino" HeaderText="POSI NO" />
<asp:BoundField DataField="description" HeaderText="DESCRIPTION" />
<asp:BoundField DataField="colour" HeaderText="COLOUR" />
<asp:BoundField DataField="deliverydate" HeaderText="RECEIVED" />
<asp:BoundField DataField="supplier" HeaderText="SUPPLIER" />
<asp:BoundField DataField="totalrev" HeaderText="TOTAL REV" />
<asp:BoundField DataField="screen" HeaderText="SCR/ANG" />
<asp:BoundField DataField="depth" HeaderText="DEPTH" />
<asp:BoundField DataField="circumference" HeaderText="CIRC" />
<asp:BoundField DataField="" HeaderText="STATUS" />
<asp:TemplateField HeaderText="USE" >
<ItemTemplate>
<asp:CheckBox ID="chkSelect" runat="server" OnCheckedChanged="OnChckedChanged" AutoPostBack="True" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
<EditRowStyle BackColor="#2461BF" />
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#EFF3FB" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#F5F7FB" />
<SortedAscendingHeaderStyle BackColor="#6D95E1" />
<SortedDescendingCellStyle BackColor="#E9EBEF" />
<SortedDescendingHeaderStyle BackColor="#4870BE" />
</asp:GridView>
please help