You should use Where Clause at End of Statement Like

SELECT *
FROM dbo.OutputPromptItem
JOIN dbo.OutputPrompt
ON dbo.OutputPromptItem.PromptId=dbo.OutputPrompt.Promp WHERE SegmentId=7198

//for each row of gridview CheckBox chk; for (int i = 0; i< GridView1.Rows.Count; i++) { chk = (CheckBox)GridView1.Rows[i].Cells[chechboxcolumnIndexInterger].FindControl("checkboxID"); }

<asp:GridView ID="GridView1" runat="server">
<Columns>
asp:TemplateField
<ItemTemplate>
<asp:Image ID="img1" runat="server" ImageUrl='<%#Eval("imageUrlFielName") %>' />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>