Pulling out 10 last posts in forum (access db)

Daniel Jahro via DotNetMonster.com · Feb 3, 2005

Hi!

Im trying to pull out the last ten posts in a access dg (*.mdb). Whats the best way to do it?

All posts are located in a table named "tblTopic" and the posts automatically get accending numbers. The first vertical row (?) with the numbers are named "Topic_ID".

Any ideas?

Thanks in advance!
-daniel

Gopal \(FMS, Inc.\) · Feb 3, 2005

Select top 10 * from tblTopic order by Topic_ID desc

You need to run the above query from an aspx page and populate a datagrid.

Hope this gets you on the right track.
--
Gopal Rangaswamy
Microsoft Certified Solutions Developer
FMS, Inc.
<http://www.fmsinc.com/consulting>
<http://www.fmsinc.com/dotnet/SourceBook/>

Daniel Jahro via DotNetMonster.com said:
Hi!

Im trying to pull out the last ten posts in a access dg (*.mdb). Whats the best way to do it?

All posts are located in a table named "tblTopic" and the posts

automatically get accending numbers. The first vertical row (?) with the
numbers are named "Topic_ID".

Daniel Jahro via DotNetMonster.com · Feb 3, 2005

Heh, i guess, but im pritty new to this, so could you by any chance be somewhat more specific?

John Timney \(ASP.NET MVP\) · Feb 3, 2005

The code below might help.....change the database name and it might just
work.....

--
Regards

John Timney
ASP.NET MVP
Microsoft Regional Director

<%@ Page Language="VB"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

<script language="VB" runat="server">
Sub Page_Load(Src as object, E as EventArgs)

Dim objConnection As OleDbConnection
Dim objCommand As OleDbCommand
Dim objDataReader As OleDbDataReader
Dim strSQLQuery As String

objConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=" & Server.MapPath("database.mdb") & ";")

strSQLQuery = "Select top 10 * from tblTopic order by Topic_ID desc"

objCommand = New OleDbCommand(strSQLQuery, objConnection)

objConnection.Open()

objDataReader = objCommand.ExecuteReader(CommandBehavior.CloseConnection)

resultsGrid.DataSource = objDataReader
resultsGrid.DataBind()

End Sub

</script>

<html>
<body>

<asp

ataGrid id="resultsGrid" runat="server"
cellspacing="1"
cellpadding="2"
HeaderStyle-Font-Bold="True"
ToolTip="This is Cool!"
MaintainViewState="false"
/>

</body>
</html>

Daniel Jahro via DotNetMonster.com · Feb 3, 2005

Where?

Patrick Olurotimi Ige · Feb 3, 2005

Daniel with the code John gave u below:-
Change this 2 lines:-

objConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=" & Server.MapPath("database.mdb") & ";")

strSQLQuery = "Select top 10 * from tblTopic order by Topic_ID desc"

change the database.mdb to your database name!
And thats it..
Hope it helps
Patrick

Sub Page_Load(Src as object, E as EventArgs)

Dim objConnection As OleDbConnection
Dim objCommand As OleDbCommand
Dim objDataReader As OleDbDataReader
Dim strSQLQuery As String

objConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=" & Server.MapPath("database.mdb") & ";")

strSQLQuery = "Select top 10 * from tblTopic order by Topic_ID desc"

objCommand = New OleDbCommand(strSQLQuery, objConnection)

objConnection.Open()

objDataReader =
objCommand.ExecuteReader(CommandBehavior.CloseConnection)

resultsGrid.DataSource = objDataReader
resultsGrid.DataBind()

End Sub

Daniel Jahro via DotNetMonster.com · Feb 4, 2005

Thanks! Im trying to get it to work..

Patrick Olurotimi Ige · Feb 4, 2005

Hi Daniel Jahro,
Good u are trying..'
Any more questions let me know.
Patrick

Problem connection to local db in VWD2010	2	Apr 17, 2010
getting last record in access db	3	Oct 25, 2003
Completely unable to update an access db from a datagrid	4	May 17, 2005
Call for Papers: MSV'10 (The 2010 International Conference onModeling, Simulation, and Visualizatio	0	Feb 23, 2010
ASP.NET Image Disply from DB still not functioning properly	5	Jun 14, 2005
Date field in DB	6	Jul 31, 2003
Select next item in DB without knowing what ID it has	11	Nov 10, 2005
How do I import a CSV data into an Access DB?	2	Jul 21, 2006

Pulling out 10 last posts in forum (access db)

Daniel Jahro via DotNetMonster.com

Gopal \(FMS, Inc.\)

Daniel Jahro via DotNetMonster.com

John Timney \(ASP.NET MVP\)

Daniel Jahro via DotNetMonster.com

Patrick Olurotimi Ige

Daniel Jahro via DotNetMonster.com

Patrick Olurotimi Ige

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads