Database sort of query

[Wizard]

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

 

[Darious Snell]

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.

 

[Peter Huang [MSFT]]

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/default.asp?url=/library/en-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.