Hey guys, I have a program I've written with MS J# and I'm working with an MS Access Database. I have a key field which is called ProjID. other columns are hDate, project name. I would like to pull down the specific Hdate for a ProjID, but have not been able to find a method to do this.

I've imported the database and it has made the following objects.

private itt_mirrorDataSet itt_mirrorDataSet;
private BindingSource projectInfoBindingSource;
private itt_mirrorDataSetProject_InfoTableAdapter itt_mirrorDataSetProject_InfoTableAdapter;

Anyone familiar with working with Databases in VB, java or otherwise that can help me out?

Thanks

9/14/2007 10:25:21 AM

convert the whole thing to sql

then write you some leet php script and be done.

9/14/2007 10:34:09 AM

getting info from an Access Database

makes me think of SQL

be obviously this is more complicated than that...

9/14/2007 10:34:29 AM

Its a little more complicated.

I want to do something like this.
SELECT [H-Date] FROM [Project Info] WHERE ProjID = " + comboBox1.selected_Value().ToString()

The J# program that i created has a drop down menu where you select the "project Name" which are elements from the ProjectName column in my access database. The "comboBox1.selected_Value()" gets ProjectID for the selected projectName, which is the key to the Database.

So from that, I want to populate a Text field with information from the Hdate column which matches up with the information from the PrjectID row.

needless to say, my sql statement above doesn't really work, but this portion does SELECT [H-Date] FROM [Project Info] WHERE ProjID = 1.

If someone could tell me how to pass the results from the Java method to the SQL statement, that would basically solve my problem.

9/14/2007 10:44:01 AM