[RESOLVED] VB.NET: site+taking data from MSSQL

[farmer]

I've just bought Visual Studio 2005. I hope my questions will be smarter soon. The last time I wrote code was C++ 5.0. So, I'm sorry for my question.

I'm watching tutorials about creating Web Site and about controls.
I think I added SQL Database to the project (it's not empty) properly. Suppose it has two columns: FirstName, LastName.
I have TextBox1, TextBox2 and Button1 on the web site form.
I enter any integer number (5, 10, 15 or whatever) into TextBox1. I want to press Button1 and get a value of 5th person (10th, 15th or whatever) from SQL Database into TextBox2.
Who can help me with that? Should I read about ADO.NET and use something from there?

Later I want to use VB for work with that strings.


Thank you.

[jmcilhinney]

I've just bought Visual Studio 2005.

That wasn't a smart move I'm afraid. VS 2008 has been available for several years and VS 2010 is only a couple of months away. For those starting out, VB Express and Visual Web Developer are both free.

I'm watching tutorials about creating Web Site and about controls.
I think I added SQL Database to the project (it's not empty) properly. Suppose it has two columns: FirstName, LastName.
I have TextBox1, TextBox2 and Button1 on the web site form.
I enter any integer number (5, 10, 15 or whatever) into TextBox1. I want to press Button1 and get a value of 5th person (10th, 15th or whatever) from SQL Database into TextBox2.
Who can help me with that? Should I read about ADO.NET and use something from there?

Yes, I'd suggest that you do some reading on the basics of ADO.NET and then post more specific questions if you don't understand something. There are several links in my signature that you'll find useful for data access.

[farmer]

That wasn't a smart move I'm afraid. VS 2008 has been available for several years and VS 2010 is only a couple of months away. For those starting out, VB Express and Visual Web Developer are both free.

I bet you are right. The only problem is VS2008 cost 4 times more than I paid for VS2005. Also, I'd better buy a newer laptop for VS2008 as it needs more resources. It's like a browser - I can read news using old version of Internet Explorer. To read news I don't need to upgrade IE5 to IE6.
Probably, I'm wrong.

Yes, I'd suggest that you do some reading on the basics of ADO.NET and then post more specific questions if you don't understand something. There are several links in my signature that you'll find useful for data access.

Thank you. Now my Text forms take some data from the database. Thank you.