Estoy realizando un par de consultas a una bDD que tengo creada en access
La estructura de la tabla es la siguiente
<TABLE cellSpacing=0 =#ffffff border=1>
<CAPTION>pedidos</CAPTION>
<T>
<TR>
<TH borderColor=#000000 =#c0c0c0>meseros</TH>
<TH borderColor=#000000 =#c0c0c0>mesa</TH>
<TH borderColor=#000000 =#c0c0c0>producto</TH>
<TH borderColor=#000000 =#c0c0c0>cantidad</TH>
<TH borderColor=#000000 =#c0c0c0>valor</TH>
<TH borderColor=#000000 =#c0c0c0>total</TH>
<TH borderColor=#000000 =#c0c0c0>hora</TH>
<TH borderColor=#000000 =#c0c0c0>fecha</TH></TR></T>
<T>
<TR vAlign=top>
<TD borderColor=#c0c0c0>Claudio</TD>
<TD borderColor=#c0c0c0>3 </TD>
<TD borderColor=#c0c0c0>Bebida CocaCola</TD>
<TD borderColor=#c0c0c0>1</TD>
<TD borderColor=#c0c0c0>1000</TD>
<TD borderColor=#c0c0c0>1000</TD>
<TD borderColor=#c0c0c0>18:49:38</TD>
<TD borderColor=#c0c0c0>22-08-2008</TD></TR>
<TR vAlign=top>
<TD borderColor=#c0c0c0>Juanito </TD>
<TD borderColor=#c0c0c0>3 </TD>
<TD borderColor=#c0c0c0>Café</TD>
<TD borderColor=#c0c0c0>1</TD>
<TD borderColor=#c0c0c0>650</TD>
<TD borderColor=#c0c0c0>650</TD>
<TD borderColor=#c0c0c0>18:49:46</TD>
<TD borderColor=#c0c0c0>22-08-2008</TD></TR>
<TR vAlign=top>
<TD borderColor=#c0c0c0>Claudio</TD>
<TD borderColor=#c0c0c0>2 </TD>
<TD borderColor=#c0c0c0>Bebida Ginger Ale</TD>
<TD borderColor=#c0c0c0>1</TD>
<TD borderColor=#c0c0c0>1000</TD>
<TD borderColor=#c0c0c0>1000</TD>
<TD borderColor=#c0c0c0>19:23:08</TD>
<TD borderColor=#c0c0c0>22-08-2008</TD></TR>
<TR vAlign=top>
<TD borderColor=#c0c0c0>Juan </TD>
<TD borderColor=#c0c0c0>4 </TD>
<TD borderColor=#c0c0c0>Café</TD>
<TD borderColor=#c0c0c0>1</TD>
<TD borderColor=#c0c0c0>650</TD>
<TD borderColor=#c0c0c0>650</TD>
<TD borderColor=#c0c0c0>19:23:17</TD>
<TD borderColor=#c0c0c0>22-08-2008</TD></TR>
<TR vAlign=top>
<TD borderColor=#c0c0c0>Claudio</TD>
<TD borderColor=#c0c0c0>2 </TD>
<TD borderColor=#c0c0c0>Champagne</TD>
<TD borderColor=#c0c0c0>3</TD>
<TD borderColor=#c0c0c0>8000</TD>
<TD borderColor=#c0c0c0>24000</TD>
<TD borderColor=#c0c0c0>19:23:27</TD>
<TD borderColor=#c0c0c0>22-08-2008</TD></TR>
<TR vAlign=top>
<TD borderColor=#c0c0c0>Claudio</TD>
<TD borderColor=#c0c0c0>1 </TD>
<TD borderColor=#c0c0c0>Tequila Sunrise</TD>
<TD borderColor=#c0c0c0>6</TD>
<TD borderColor=#c0c0c0>2800</TD>
<TD borderColor=#c0c0c0>16800</TD>
<TD borderColor=#c0c0c0>19:23:38</TD>
<TD borderColor=#c0c0c0>22-08-2008</TD></TR>
<TR vAlign=top>
<TD borderColor=#c0c0c0>Juan </TD>
<TD borderColor=#c0c0c0>4 </TD>
<TD borderColor=#c0c0c0>Bebida CocaCola</TD>
<TD borderColor=#c0c0c0>2</TD>
<TD borderColor=#c0c0c0>1000</TD>
<TD borderColor=#c0c0c0>2000</TD>
<TD borderColor=#c0c0c0>19:24:06</TD>
<TD borderColor=#c0c0c0>22-08-2008</TD></TR>
<TR vAlign=top>
<TD borderColor=#c0c0c0>Juanito </TD>
<TD borderColor=#c0c0c0>1 </TD>
<TD borderColor=#c0c0c0>Pisco Sour</TD>
<TD borderColor=#c0c0c0>5</TD>
<TD borderColor=#c0c0c0>1350</TD>
<TD borderColor=#c0c0c0>6750</TD>
<TD borderColor=#c0c0c0>19:24:20</TD>
<TD borderColor=#c0c0c0>22-08-2008</TD></TR></T>
<TFOOT></TFOOT></TABLE>
Mi codigo es el siguiente
ruta = [color=#800000 size=2][color=#800000 size=2]"C:\pub.mdb"
[/color][/color]conexion.ConnectionString = [color=#800000 size=2][color=#800000 size=2]"provider=microsoft.jet.oledb.4.0;data source="[/color][/color] & ruta
conexion.Open()
comando.Connection = conexion
adapter.SelectCommand = comando
adapter.SelectCommand.CommandText = [color=#800000 size=2][color=#800000 size=2]"select pedidos.meseros from pedidos where pedidos.mesa='"[/color][/color] + combomesa.Text + [color=#800000 size=2][color=#800000 size=2]"'"[/color][/color]
adapter.Fill(midataset, [color=#800000 size=2][color=#800000 size=2]"pedidos"[/color][/color])
oledbreader = comando.ExecuteReader
[color=#0000ff size=2][color=#0000ff size=2]Do[/color][/color] [color=#0000ff size=2][color=#0000ff size=2]While[/color][/color] oledbreader.Read
ComboBox1.Items.Add(oledbreader.Item([color=#800000 size=2][color=#800000 size=2]"meseros"[/color][/color]))
[color=#0000ff size=2][color=#0000ff size=2]Loop
En el Combomesa.text esta seleccionado el número 1, por lo que ahora en el combobox1 debería aparecer Claudio y Juanito, pero no me sale nada, queda en blanco. Tengo varias consultas echas de la misma forma, pero no había tenido problemas como este.
Gracias a todos.[/color][/color]