{"id":625,"date":"2011-03-30T11:12:17","date_gmt":"2011-03-30T15:12:17","guid":{"rendered":"http:\/\/www.iowawebnet.com\/ein\/?p=625"},"modified":"2011-04-18T11:12:53","modified_gmt":"2011-04-18T15:12:53","slug":"simple-record-query-inside-gridview","status":"publish","type":"post","link":"https:\/\/www.iowawebnet.com\/ein\/2011\/03\/simple-record-query-inside-gridview\/","title":{"rendered":"Simple record query inside gridview"},"content":{"rendered":"

Here is simple record query inside the datagrid. I was looking for this solution which does not require code behind.<\/p>\n

Access DB structure
\n<\/strong><\/p>\n

<\/a>\"\"<\/a><\/p>\n

Detail.aspx<\/strong> page code:<\/p>\n

<form id=<\/span>“form1” runat=<\/span>“server”><\/span>
\n<div>
\n<asp:GridView ID=”GridView1″ runat=”server” AutoGenerateColumns=”False”
\nDataKeyNames=”ID” DataSourceID=”DetailView” GridLines=”None”>
\n<Columns><\/span>
\n<asp:TemplateField>
\n<ItemTemplate><\/span>
\n<table width=”660px” border=”0″ cellpadding=”0″ cellspacing=”0″>
\n<tr>
\n<td colspan=”4″>
\n<a href=”Detail.aspx?cid=<%#Container.DataItem(“ID”)%>&pic=p1″><img src=”images\/<%# Container.DataItem(“Pic1″)%>” width=”75px” height=”54px” border=”0″\/><\/a>&nbsp;
\n<%
\nDim vid As String
\nvid = Request.QueryString( “cid”<\/span> )
\n‘\/ access db connection – MS Access 2007\/10 driver * you can define your own sql connection
\nDim ConnDB As New OleDbConnection(“Provider=Microsoft.ACE.OLEDB.12.0;Data Source=” & Server.MapPath<\/span>(“\/my_folder\/my.mdb”<\/span>))
\nDim cmd As New OleDbCommand(“SELECT * FROM MyCars WHERE (ID = ” & vid &<\/span> “);”<\/span>, ConnDB)
\nDim reader As OleDbDataReader<\/p>\n

‘\/ open connection
\ncmd.Connection.Open()<\/span>
\nreader = cmd.ExecuteReader()
\nIf reader.Read() Then
\nIf (reader(“Pic2”<\/span>).ToString() <> “np.jpg”<\/span>) Then
\n%>
\n<a href=”Detail.aspx?cid=<%#Container.DataItem(“ID”<\/span>)%>&pic=p2″><img src=”images\/<%# Container.DataItem(“Pic2”<\/span>)%>” width=”75px” height=”54px” border=”0″\/><\/a>&nbsp;
\n<%
\nEnd If
\nIf (reader(“Pic3”<\/span>).ToString() <> “np.jpg”<\/span>) Then
\n%>
\n<a href=”Detail.aspx?cid=<%#Container.DataItem(“ID”<\/span>)%>&pic=p3″><img src=”images\/<%# Container.DataItem(“Pic3”<\/span>)%>” width=”75px” height=”54px” border=”0″\/><\/a>&nbsp;
\n<%
\nEnd If
\nIf (reader(“Pic4”<\/span>).ToString() <> “np.jpg”<\/span>) Then
\n%>
\n<a href=”Detail.aspx?cid=<%#Container.DataItem(“ID”<\/span>)%>&pic=p4″><img src=”images\/<%# Container.DataItem(“Pic4”<\/span>)%>” width=”75px” height=”54px” border=”0″\/><\/a>&nbsp;
\n<%
\nEnd If
\nIf (reader(“Pic5”<\/span>).ToString() <> “np.jpg”<\/span>) Then
\n%>
\n<a href=”Detail.aspx?cid=<%#Container.DataItem(“ID”<\/span>)%>&pic=p5″><img src=”images\/<%# Container.DataItem(“Pic5”<\/span>)%>” width=”75px” height=”54px” border=”0″\/><\/a>&nbsp;
\n<%
\nEnd If
\nIf (reader(“Pic6”<\/span>).ToString() <> “np.jpg”<\/span>) Then
\n%>
\n<a href=”Detail.aspx?cid=<%#Container.DataItem(“ID”<\/span>)%>&pic=p6″><img src=”images\/<%# Container.DataItem(“Pic6”<\/span>)%>” width=”75px” height=”54px” border=”0″\/><\/a>&nbsp;
\n<%
\nEnd If
\nIf (reader(“Pic7”<\/span>).ToString() <> “np.jpg”<\/span>) Then
\n%>
\n<a href=”Detail.aspx?cid=<%#Container.DataItem(“ID”<\/span>)%>&pic=p7″><img src=”images\/<%# Container.DataItem(“Pic7”<\/span>)%>” width=”75px” height=”54px” border=”0″\/><\/a>&nbsp;
\n<%
\nEnd If
\nIf (reader(“Pic8”<\/span>).ToString() <> “np.jpg”<\/span>) Then
\n%>
\n<a href=”Detail.aspx?cid=<%#Container.DataItem(“ID”<\/span>)%>&pic=p8″><img src=”images\/<%# Container.DataItem(“Pic8”<\/span>)%>” width=”75px” height=”54px” border=”0″\/><\/a>&nbsp;
\n<%
\nEnd If
\nEnd If
\ncmd.Connection.Close()<\/span>
\n%>
\n<\/td>
\n<\/tr>
\n<tr>
\n<td><span>Year:<\/span><\/td><td><%# Container.DataItem(“vYear”<\/span>)%><\/td>
\n<td><span>Exterior:<\/span><\/td><td><%# Container.DataItem(“Exterior”)%><\/td>
\n<\/tr>
\n<tr>
\n<td><span>Make:<\/span><\/td><td><%# Container.DataItem(“Make”<\/span>)%><\/td>
\n<td><span>Interior:<\/span><\/td><td><%# Container.DataItem(“Interior”<\/span>)%><\/td>
\n<\/tr>
\n<tr>
\n<td><span>Model:<\/span><\/td><td><%# Container.DataItem(“Model”<\/span>)%><\/td>
\n<td><span>Starting Bid:<\/span><\/td><td><%# DataBinder.Eval(Container.DataItem, “sFloor”<\/span>, “{0:c0}”) %><\/td>
\n<\/tr>
\n<tr>
\n<td><span>Mileage:<\/span><\/td><td><%# DataBinder.Eval(Container.DataItem, “Mileage”<\/span>, “{0:#,##0} mi”)%><\/td>
\n<td><span>VIN:<\/span><\/td><td><%# Container.DataItem(“VIN”<\/span>)%><\/td>
\n<\/tr>
\n<\/table>
\n<\/ItemTemplate><\/span>
\n<\/asp:TemplateField>
\n<\/Columns><\/span>
\n<\/asp:GridView>
\n<asp:AccessDataSource ID=”DetailView” runat=”server” DataFile=”\/my_folder\/mydb.mdb”
\nSelectCommand=”SELECT * FROM [MyCars] WHERE ([ID] = ?)”>
\n<SelectParameters>
\n<asp:QueryStringParameter Name=”ID” QueryStringField=”cid” Type=”Int32″ \/>
\n<\/SelectParameters>
\n<\/asp:AccessDataSource>
\n<\/div>
\n<\/form><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Here is simple record query inside the datagrid. I was looking for this solution which does not require code behind. Access DB structure Detail.aspx page code: <form id=“form1” runat=“server”> <div> <asp:GridView ID=”GridView1″ runat=”server” AutoGenerateColumns=”False” DataKeyNames=”ID” DataSourceID=”DetailView” GridLines=”None”> <Columns> <asp:TemplateField> <ItemTemplate> <table width=”660px” border=”0″ cellpadding=”0″ cellspacing=”0″> <tr> <td colspan=”4″> <a href=”Detail.aspx?cid=<%#Container.DataItem(“ID”)%>&pic=p1″><img src=”images\/<%# Container.DataItem(“Pic1″)%>” width=”75px” height=”54px” border=”0″\/><\/a>&nbsp; […]<\/p>\n","protected":false},"author":35,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28,17,16],"tags":[30,19,42],"class_list":["post-625","post","type-post","status-publish","format-standard","hentry","category-access","category-applications","category-net","tag-access-2","tag-asp-net","tag-gridview"],"_links":{"self":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/625"}],"collection":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/users\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/comments?post=625"}],"version-history":[{"count":15,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/625\/revisions"}],"predecessor-version":[{"id":758,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/625\/revisions\/758"}],"wp:attachment":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/media?parent=625"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/categories?post=625"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/tags?post=625"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}