Re: C# + Access Database Problem
- From: "Gordon Smith \(eMVP\)" <Gordon.Smith@xxxxxxxxxxxxxxxx>
- Date: Thu, 13 Jul 2006 16:06:15 -0700
ATXTech wrote:
I am using a Access created database with a program I wrote in C# to
create and track helpdesk tickets. I store basic stuff like customer
name, number, issue, tech assigned, etc. with in the database.
**PROBLEM**
The database worked fine in saving and displaying records until it
reaced the 26th record. When ever you open the ticket program, it
retrieves the data from the database on the server and shows the last
entry in the database first. For example the tickets show like this:
28,27,26,1,2,3,4...How do I get it to show the last ticket entered at
the end. The actual database when opened in Access looks fine and
displays the tickets in the order they where entered
(1,2,3...25,26,27). It's only when the "program" displays the records
does it appear the way it does. It's like it reads the last records
first and then the first one on down. Please help!! Thank you!
It sounds like you don't have your result set sorted. Saying how to help is
hard since I don't know how exactly you retrieved your result set. If based
off of the base table directly, you need to specify an index to use for
ordering. If based off of a query, you'd want to have an ORDER BY in your
query string. etc.
--
Gordon Smith (eMVP)
-- Avnet Applied Computing Solutions
.
- Follow-Ups:
- Re: C# + Access Database Problem
- From: ATXTech
- Re: C# + Access Database Problem
- References:
- C# + Access Database Problem
- From: ATXTech
- C# + Access Database Problem
- Prev by Date: Re: Regarding splitting Large xml files to smaller xm files
- Next by Date: Re: How to inherit if base class is burned?
- Previous by thread: C# + Access Database Problem
- Next by thread: Re: C# + Access Database Problem
- Index(es):
Relevant Pages
|
