User Profile

Collapse

Profile Sidebar

Collapse
Temidayo
Temidayo
Last Activity: Jun 3 '10, 07:08 AM
Joined: Aug 6 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Temidayo
    started a topic SEARCH: It worked for me in VB.NET but doesn't work in ASP.NET
    in .NET

    SEARCH: It worked for me in VB.NET but doesn't work in ASP.NET

    Please, Resourceful Members of the House,

    I tried to perform a search in ASP.NET (which I implemented in VB.NET and worked successfully) with the following lines of codes:

    Protected Sub txtSNameSearch_ TextChanged(ByV al sender As Object, ByVal e As System.EventArg s) Handles txtSNameSearch. TextChanged

    Dim dt As New DataTable
    Dim conn As New SqlConnection(" Data Source=.;Initia l...
    See more | Go to post
    • Temidayo
      replied to Select TOP x number of records
      in Access
      Can u try something like this?...

      SELECT TOP " & v & " PERCENT
      FirstName, LastName
      FROM Students
      WHERE GraduationYear = 1994
      ORDER BY GradePointAvera ge ASC;

      where v is your passed in variable.

      Good Luck...
      See more | Go to post

        Leave a comment:

      • Temidayo
        started a topic Retrieving Last 'N' records from a Table in the Database
        in SQL Server

        Retrieving Last 'N' records from a Table in the Database

        Hello House,

        Please, I need the SQL statement/keyword used to Retrieve the Last 'N' records from a table in the Database; just as we have TOP 'N' for the First N-records in a table.

        For example, ("Select TOP 'N' * From Particulars Order by Phone DESC", conn)

        where N is the number of records to be retrieved.

        I use both SQL Server 2005 and Microsoft Access.

        Thanks...
        See more | Go to post
        No activity results to display
        Show More
        Working...