Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Hello, Is there a way to display
- Thread starter Roberti
- Start date
Sure!
Since I dont know how familiar you are to ASP we´ll take it step by step:
1. Run your query like this:
-----------------------------------------------
SQL = "Select firstname,lastname from People"
RS.Open SQL,Conn
2. Loop all the records until EOF is true (EOF = End Of File)
-----------------------------------------------
DO WHILE NOT RS.EOF
[ code to execute, eg. Response.Write(RS("firstname"
) ]
RS.MoveNext
Loop
3. Close RS
The above example works if you have a declared recordset called RS and a databasen connection declared as Conn.
If you have that the code will print all the first names in the table People (my example that is =) )
Good luck!
Since I dont know how familiar you are to ASP we´ll take it step by step:
1. Run your query like this:
-----------------------------------------------
SQL = "Select firstname,lastname from People"
RS.Open SQL,Conn
2. Loop all the records until EOF is true (EOF = End Of File)
-----------------------------------------------
DO WHILE NOT RS.EOF
[ code to execute, eg. Response.Write(RS("firstname"
) ]RS.MoveNext
Loop
3. Close RS
The above example works if you have a declared recordset called RS and a databasen connection declared as Conn.
If you have that the code will print all the first names in the table People (my example that is =) )
Good luck!
- Thread starter
- #3
Whell, I have a qry in access from wich I want the results displayed in a table. I've got a working code, but that is for ASP.net, and the server on wich it must run doesn.t support asp.net, And i'm unsuccesfull of converting the code to ASP. The asp.net code is:
<%@ Import Namespace="System.Data.OLEDB" %>
<%@ Page Language="VB" 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("\Database\Storingsformulier.mdb" & ";"
Dim strSQL as string ="select * from qry_test"
Dim Conn as New OLEDBConnection(strConn)
Dim Cmd as New OLEDBCommand(strSQL,Conn)
Conn.Open()
myDataGrid.DataSource = Cmd.ExecuteReader(system.data.CommandBehavior.CloseConnection)
myDataGrid.DataBind()
End Sub
</script>
<html>
<head><title>Test</title></head>
<body bgcolor="#FFFFFF">
<font face="Verdana"><h3>Test</h3></font>
<ASPataGrid 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>
how the table looks isn't important, just that the results of the query 'qry_test' are shown in a table.
Roberti
<%@ Import Namespace="System.Data.OLEDB" %>
<%@ Page Language="VB" 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("\Database\Storingsformulier.mdb"
& ";" Dim strSQL as string ="select * from qry_test"
Dim Conn as New OLEDBConnection(strConn)
Dim Cmd as New OLEDBCommand(strSQL,Conn)
Conn.Open()
myDataGrid.DataSource = Cmd.ExecuteReader(system.data.CommandBehavior.CloseConnection)
myDataGrid.DataBind()
End Sub
</script>
<html>
<head><title>Test</title></head>
<body bgcolor="#FFFFFF">
<font face="Verdana"><h3>Test</h3></font>
<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>
how the table looks isn't important, just that the results of the query 'qry_test' are shown in a table.
Roberti
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question