HOLA UNA CONSULTA ESTOY TRATANDO DE JALAR UN ID DE UNA BASE DE DATOS PERO QUIERO Q ME JALE CUANDO YO SELECIONO EL BOTON RESERVAR DE LA MESA PERO NO SE POR QUE ME JALA SIEMPRE LA ULTIMA MESA MUCHAS GRACIAS ACA LE DEJO EL CODIGO
<!-- Gallery Filter -->
<%
Response.Write("<ul id='filter-by' class='clearfix'>")
Response.Write(" <!-- Gallery Container -->")
Response.Write(" <div id='gallery-container' class='gallery-3-columns isotope clearfix'>")
Dim MiConexion As New ConexionDAO
Dim cnx As New SqlConnection(MiConexion.GetCnx)
Dim dtr As SqlDataReader
Dim cmd As New SqlCommand
Dim _MesBE As New MesasBE
cmd.Connection = cnx
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "LISTAR_MESA_PAG"
cmd.Parameters.Add(New SqlParameter("@COD_SEDE", SqlDbType.Char, 6))
cmd.Parameters("@COD_SEDE").Value = CboSede.SelectedValue
cnx.Open()
dtr = cmd.ExecuteReader
If dtr.HasRows = True Then
While dtr.Read()
Session("COD_MESA") = dtr(0)
Response.Write("<div class=' gallery-item type-gallery-item gallery-item isotope-item food interior '>")
Response.Write("<figure>")
Response.Write("<div class='media_container'>")
Response.Write("<a class='pretty-photo zoom' href='../images/MESAS/" + dtr(9) + "' title='Numero De Sillas " + Convert.ToString(dtr(2)) + "'></a>")
Response.Write("<a class='link' href='Descripcion-Plato.aspx'></a>")
Response.Write(" <asp:Button ID='Button1' runat='server' Text='Button' />")
Response.Write("</div>")
Response.Write("<img class='img-border' src='../images/MESAS/" + dtr(9) + "' Width='241px' Height='147px' alt='" + dtr(1) + "'>")
Response.Write("</figure>")
Response.Write(" <asp:Button runat='server' Text='Button'></asp:Button> ")
Response.Write("<h5 class='item-title'><a href='default.aspx' title='" + dtr(1) + "'>" + Convert.ToString(dtr(1)) + "</a></h5>")
%>
<asp:Button ID='btn' runat='server' Text='RESERVAR' PostBackUrl="~/WEB/reserva.aspx" /></asp:Button>
<%
Response.Write("</div>")
End While
End If
%>