473,326 Members | 2,095 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Database sort of query

Hi,

I have a database with controls on a form:

Student >> Class >> Date >> Grade at Present >>> Predicted >>> DOB

The Grade and the Predict often change, how do i get it so the I could add a
button on my form called "History" and within there have a form with the
dates on the table had changed ie the Predicted and Present grades and the
Data they were changed?

Cheers
Wizard
Nov 21 '05 #1
2 1152
The gist is this -
You need to be able to persist your data.
You said you have a database.
So, in that database you have a table (or tables)
to store your data. If you have a single table,
each row should have a unique value. Likely the primary key you defined.

In vb.net, you would use an OleDbDataAdapter.
Once configured, you would generate a dataset schema/object.
Then, you would use the .fill method of the dataadapter to fill the dataset.
You could also have a combo box filled with student names and IDs on the form.
You could use the student ID as a parameter in your database query.

If the dataset was bound to a grid on your form, and the .fill was executed in the button
click event of your button, you would be able to see history in the grid.

Take a good look at the helpfiles regarding the words

DataSet
DataAdapter
Data Binding
Parameter
Query
If you don't have SQL Server, you can also use vb to create an MS Access database.

Hope this helps.

"Wizard" <te**@test.com> wrote in message news:UX********************@karoo.co.uk...
Hi,

I have a database with controls on a form:

Student >> Class >> Date >> Grade at Present >>> Predicted >>> DOB

The Grade and the Predict often change, how do i get it so the I could add a
button on my form called "History" and within there have a form with the
dates on the table had changed ie the Predicted and Present grades and the
Data they were changed?

Cheers
Wizard

Nov 21 '05 #2
Hi

Thanks for Wizard's good suggestion about ado.net and databinding.
Also here is a link you may take a look.
http://www.funducode.com/csharpart/csarticle56.htm

For .net data accessing you may start from the link below.

Accessing Data with ADO.NET
http://msdn.microsoft.com/library/de...us/cpguide/htm
l/cpconAccessingDataWithADONET.asp

As for the detailed scenario, I can not understanding your issue very well,
can you restate the problem more detailed?
Best regards,

Perter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

Nov 21 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Marcus | last post by:
Hello, Say I have a function with 5 MySQL queries that all insert or update the database. Now let's assume that during execution, the first 3 queries are executed fine but then the 4th one dies...
5
by: krystoffff | last post by:
I currently have PostgreSQL 7.1 installed on a server with about 700 Mb of RAM. I have many problems of speed with a database I created. For example, it took almost 12 sec to run the query...
7
by: Foxster | last post by:
in access i have two tables (tblplayer, tblpoints) in tblplayer i have field totalpoint (number) in tlbpoints i have field pointgame (number) the two files are related via idplayer now i made a...
1
by: Lloyd Stevens | last post by:
CustomerTable CustomerTarrifTable TarrifTable WarrantTable *CustomerID CustomerID ProductName *WarrantID BoatType *CustomerTarrifID TarrifRate WarrantDate CustomerName ...
2
by: Carl Summers | last post by:
I have a table in an Access database that has no sort applied in Access. When I fill a dataset with data from that table (the entire one dimensional table) my dataset is sorted differently than...
29
by: MP | last post by:
Greets, context: vb6/ado/.mdb/jet 4.0 (no access)/sql beginning learner, first database, planning stages (I think the underlying question here is whether to normalize or not to normalize this...
3
by: ATXTech | last post by:
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...
9
greensleeves
by: greensleeves | last post by:
Hi, Im a newbie to PHP and I'm wondering if someone could help me out with this Tryng to search out products from a database by clicking a checkbox option for instance if description contains...
4
by: sialater | last post by:
Hello, I realise there are a lot of topics related to this problem but many of what I have found has run cold or unresolved. What I have is an addressbook clone where there are groups which have...
39
by: alex | last post by:
I've converted a latin1 database I have to utf8. The process has been: # mysqldump -u root -p --default-character-set=latin1 -c --insert-ignore --skip-set-charset mydb mydb.sql # iconv -f...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.