Accessing an SQL table from VB code? NEWBIE QUESTION

[JumpyNET]

Hello,

I'm just starting with SQL. So far I've installed SQL Server Express and SQL Server Management Studio Express. I have also managed to start a server and create a table called "table1" there. On the table I have two columns and two entries(rows).

 

Could someone please give me a simple sample code for reading the cell values from my "table1" and for adding a new row.

 

 

I also appreciate links for good tutorials for beginners in SQL Server Express.

 

PS: I'm using Visual Basic 2005 Express.

[IUnknown]

The are heaps of walkthroughs on data access in the Top Secret .Net Programmers resource

[JumpyNET]

The are heaps of walkthroughs on data access in the Top Secret .Net Programmers resource

 

Thanks I will check it out.

 

On the mean time I'm still open for short sample codes.

 

It's a shame you can't search the word SQL on this forum.

[IUnknown]

This is a good place to start learning SQL : SQL Tutorial.