Line 9: Dim Cmd as New OLEDBCommand(strSQL,Conn)
Line 10: Conn.Open()
Line 11: myDataGrid.DataSource = Cmd.ExecuteReader(system.data.CommandBehavior.Clos eConnection)
Line 12: myDataGrid.DataBind()
Line 13: End Sub
-----
Ya no se que hacer... ¿alguna idea?
--------
Código Completo:
<%@ Import Namespace="System.Data.OLEDB" %>
<%@ Page Debug=True %>
<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
Dim strConn as string ="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & server.mappath("test.mdb") & ";"
Dim strSQL as string ="select * from database"
Dim Conn as New OLEDBConnection(strConn)
Dim Cmd as New OLEDBCommand(strSQL,Conn)
Conn.Open()
myDataGrid.DataSource = Cmd.ExecuteReader(system.data.CommandBehavior.Clos eConnection)
myDataGrid.DataBind()
End Sub
</script>
<html><head>
<title>Grid de la tabla TEST</title>
</head>
<body bgcolor="#FFFFFF">
<font face="Verdana"><h3>Datos de la tabla en un Datagrid.</h3></font>
<ASP:DataGrid id="MyDataGrid" runat="server"
Width="100%"
BackColor="white"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
Headerstyle-BackColor="lightblue"
Headerstyle-Font-Size="10pt"
Headerstyle-Font-Style="bold"
MaintainState="false"
/>
</body></html>
¿Qué falla?
Gracias.
Salvador Gallego.
