Great Example of MDB Tomtt, But it didn't wor

useri · Apr 28, 2012

Ok, I created the table just as you told me (File Name: Test.mdb; Table name: TestTable and Top Fields Names: rID -autonumber-, rDate -date-, rName -text- and rScore -number- ). Then I copy and paste your code, and modify it just to view the data wich I had put on the Access table but the only result that I get is a Blank Page :-( , at least asp.net don't report any errors so I think this is probably a little Error... This is the little code I used: ---------------------------- <%@ Page Language="VB" %> <%@ Import NameSpace="System.Data" %> <%@ Import NameSpace="System.Data.OleDb" %> <SCRIPT RUNAT="SERVER"> sub Page_Load(obj as Object, e as EventArgs) ' CREATE OBJECTS, OPEN DB, LOAD DATASET, LOAD DATA GRID. ' CREATE DATASET AND ADD NEW DATATABLE TO IT. Dim objDSet As New DataSet Dim tblTest As DataTable = objDSet.Tables.Add("tblTest") ' CREATE CONNECTION STRING AND SELECT COMMAND. Dim objConn As New oleDBConnection ("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=C:InetPubwwwrootTest.mdb") Dim objSelect As New oleDBCommand("SELECT * FROM TestTable ORDER BY rDate DESC", objConn) ' Should I put a "objDGrid.DataBind()" here? aniway it doesn't work... End sub </SCRIPT>  <HTML><BODY> <ASP

ataGrid id="objDGrid" align="Center" runat="Server" Width = "400" BorderColor="Black" BackColor="#ffffff" CellPadding=3 CellSpacing="0" Font-Name="Verdana" AllowSorting="False" Font-Size="8pt" HeaderStyle-BackColor="#cfcfcf" enableViewState="false" /> </BODY></HTML> ---------------------------- Hope somebody can localice the error, aniway Thanks a lot for this code Tomtt ;-) Sorry again for my pour english grammar, and thanks for your time. From Spain: Salvador Gallego.Thanks aniway for those who answered to my post before. I hope I can work now more fluently after have the access to the data!. After try with one thousand of examples, and post 7 times to diferent forums places, the simple code I was searching is the following: --------------------- <%@ Import Namespace="System.Data.OLEDB" %> <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 TestTable" 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>Mis datos</title> </head> <body bgcolor="#FFFFFF"> <h3>La tabla resultado, es esta: </h3> <ASP

ataGrid 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> --------------------- This realy works and I know that is very simple, but I really didn't be able to found it anywhere... Well, hope it can be useful to somebody; From Spain: Salvador Gallego.<%@ Page Language="VB" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OleDb" %> <script runat="server"> Sub Page_Load(Sender as Object, E as EventArgs) 'Set up connection Dim objConn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:inetpubwwwroot est.mdb") 'Open Connection Dim objCmd As New OLEDbDataAdapter("Select * FROM TestTable ORDER BY rDate DESC", objConn) 'Fill Dataset Dim ds As DataSet = new DataSet() objCmd.Fill(ds, "TestTable") MyDataGrid.DataSource = ds.Tables("TestTable").DefaultView MyDataGrid.DataBind() End Sub </script> <html> <body> <form runat="server"> <ASP

ataGrid id="MyDataGrid" runat="server" BorderColor="black" GridLines="vertical" Cellpadding="4" Cellspacing="0" Width="450" Font-Names="Arial" Font-Size="8pt" ShowFooter="True" HeaderStyle-BackColor="#CCCC99" FooterStyle-BackColor="#CCCC99" ItemStyle-BackColor="#FFFFFF" AlternatingItemStyle-BackColor="#CCCCCC" AutoGenerateColumns="False"> <Columns> <asp:BoundColumn HeaderText="ID" DataField="rID"/> <asp:BoundColumn HeaderText="Date" DataField="rDate"/> <asp:BoundColumn HeaderText="Name" DataField="rName"/> <asp:BoundColumn HeaderText="Score" DataField="rScore"/> </Columns> </ASP

ataGrid> </form> </body> </html><%@ Page Language="VB" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OleDb" %> <script runat="server"> Sub Page_Load(Sender as Object, E as EventArgs) 'Set up connection Dim objConn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:inetpubwwwroot est.mdb") 'Open Connection Dim objCmd As New OLEDbDataAdapter("Select * FROM TestTable ORDER BY rDate DESC", objConn) 'Fill Dataset Dim ds As DataSet = new DataSet() objCmd.Fill(ds, "TestTable") MyDataGrid.DataSource = ds.Tables("TestTable").DefaultView MyDataGrid.DataBind() End Sub </script> <html> <body> <form runat="server"> <ASP

ataGrid id="MyDataGrid" runat="server" BorderColor="black" GridLines="vertical" Cellpadding="4" Cellspacing="0" Width="450" Font-Names="Arial" Font-Size="8pt" HeaderStyle-BackColor="#CCCC99" ItemStyle-BackColor="#FFFFFF" AlternatingItemStyle-BackColor="#CCCCCC" AutoGenerateColumns="False"> <Columns> <asp:BoundColumn HeaderText="ID" DataField="rID"/> <asp:BoundColumn HeaderText="Date" DataField="rDate"/> <asp:BoundColumn HeaderText="Name" DataField="rName"/> <asp:BoundColumn HeaderText="Score" DataField="rScore"/> </Columns> </ASP

ataGrid> </form> </body> </html>Salvador, Sorry for not responding sooner (server down). I looked at the code you posted, to see why it would not work since the example I sent was straight from a working file. Looks like maybe you didn't copy all of the file from the messageboard. Anyway, I see you are using a datareader to do the same thing and have it working. Good luck with your coding. TomT

Great Example of MDB Tomtt, But it didn't wor

useri

New Member