Beginner question on how to view database items on forms

[John Cassell]

Hi There,

hope someone can help me with creating my first form using VS2005. I have one table created in my database.

Table Name: Jobs
Fields: Job_Number, Start_Date, Complete_Date, Labour_Value, Material_Value

I have 2 jobs in there and would like to know the easiest way to get all the fields in my table onto the form and then when I type '1' in the job number box it will bring up Job 1 along with the details of the corresponding fields.

I have created quite an involved MS Access version of my Job System but would like to move onto VS.

Please accept my apologies if it seems like I haven't looked at previous posts but I simply do not know what questions to look for!

If there is any etiquette I am not aware of while writing posts, would you please let me know..

Thanks in advance.

John

 

[AIS4U]

Hi John:

Well, I guess I am not going to be able to tell you all you would need to know to complete your app, but here are some things you might want to check out.
A lot of people I know have found Microsoft's Videos very helpful in getting started with .Net. You can find them here and download them if you want to:

http://msdn2.microsoft.com/en-us/vbasic/ms789057.aspx

A couple of other links you might find helpful are:

http://www.devarticles.com/c/b/ADO.NET/

http://samples.gotdotnet.com/quickstart/howto/

http://samples.gotdotnet.com/quickstart/howto/doc/adoplus/ADOPlusOverview.aspx

I guess about all any of us can do if we are not going to take a formal class is to read lots of books, browse the Internet and visit Forums like this.

Good Luck

 

[John Cassell]

Hi,

Thanks very much for the reply and all the information. I'll check it all out now.

Really appreciate it.

Thanks again.

John

 

[cjard]

The most useful thing you will ever read in relation to ADO.NET usage in .NET2, is in the DW2 link in my signature

Please note that, on this forum, there is a special section for queries like this (ADO.NET). The Data Access forum is not for ado.net specific queries..

As a roung guide, if your post mentions any of the following words:

DataSet
DataAdapter
TableAdapter
DataTable

Then it should be in ADO.NET, just so you know for future.

 

[John Cassell]

Hi,

I have actually been reading your DW2 link and found it to be very useful. So thank you for that.

Also, thanks for the ADO.NET tip, I have been avoiding them topics as I thought they have nothing to do with what I was look for!!

Thanks very much

John