I've created a game and want to record highscores through textboxes. I've thought using an Access database may be one idea but seems quite complicated at my level of programming. I'm looking for some ideas or an alternative to using access. If not then some way i could go about using an access database?
pickleleon
0
Newbie Poster
Recommended Answers
Jump to PostSELECT query.
SELECT TOP 10 score from TableName order by score desc
Jump to PostTake a look at adatapost's above code snippet. That statement will sort your selected values from highest to lowest. The table itself may not be ordered that way, but it doesn't need to be when you use the ORDER BY statement.
All 7 Replies
kvprajapati
1,826
Posting Genius
Team Colleague
SELECT query.
SELECT TOP 10 score from TableName order by score desc
nick.crane
342
Veteran Poster
Have you looked at saving the high score table to a project settings value.
Or saving to a simple csv file on disk.
pickleleon
0
Newbie Poster
I've looked around and I'm going to try and use sql, I'm a student so I'm only just learning the basics of C#. Would i be able to order my table highest integer to lowest so I could reference a cells for my text boxes?
Sodabread
88
Posting Whiz in Training
Take a look at adatapost's above code snippet. That statement will sort your selected values from highest to lowest. The table itself may not be ordered that way, but it doesn't need to be when you use the ORDER BY statement.
pickleleon
0
Newbie Poster
Oh my bad, I didn't realise that was a line of code. Would that work for access, sql's not working for me?
Sodabread
88
Posting Whiz in Training
I believe it should. Most keywords work across a good chunk of the databases out there. Give it a shot and see if it works for you.
JOSheaIV
119
C# Addict
Just import and export from a text file. I myself and not very familiar with database, so I use use txt files and build classes that read and export the stuff into an array I can display
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.