Help with Code

[dvannoy]

OK, first of all I am new to the .NET world to forgive me.
I come from a VB6 environment.

I am trying to get into .NET by building a simple web application that connects to an access database. I cant believe how much different VB6 code is from .NET code. heres what i have got so far.

Dim cn As OleDb.OleDbConnection
Dim rs as OleDb.OleDbCommand

cn = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OlEDB.4.0;Data Source=C:\Database.mdb&quot

cn.Open

rs = New OleDb.OleDbCommand("SELECT * FROM Table", cn)

Now how do I use BOF and EOF ??

Also I want to put textboxes on the form that show the data.

the VB6 Way is Text1.Text = rs.Fields("FieldName&quot & ""

how the hell do you do this in .NET??

does ASP.NET and VB.NET have different commands as well??

theres no good help with this that I can find.. what am i doing wrong??

any help or feedback would be appreciated

Thanks

 

[Zarcom]

check it out here

http://msdn.microsoft.com/library/d...throughDisplayingDataInGridInWebFormsPage.asp

That'l do donkey, that'l do
Mark
If you are unsure of forum etiquette check here faq796-2540

 

[Isadore]

dvannoy:

We're getting ready to switch over to the SQL Server but I built a dot NET Access OLEDB website in Notepad. No code behind pages, everything is in a single aspx page. I'd be more than happy to send you several pages which has the code available and might help you get a feel for VB in dot net. You can look at the site and request any or several pages and I can email them to you.

The site is located at:

http://frontpage.auburn.edu/icaae/index.aspx

My email is biochem3d@cs.com

Would be glad to help...

 

[dvannoy]

Thanks perfect...I just sent you an email..

 

[Isadore]

No problemo...