Data Base and Data set

[Prity]

Hi Friends

I know little bit abt the SQL DB and Data set.... well i want to have complete knowledge abt these 2.... well i hav created this below program this morning...

Imports System.Data.SqlClient
Public Class Form1
    Private cs As New SqlConnection(connectionstring)
    Private ds As New DataSet
    private da as SqlDataAdapter("select * from contacts_tbl",cs) 


    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        cs.Open()
        MsgBox(cs.State.ToString)
        cs.Close()
    End Sub

End Class

And i understood what it does.... in the same can any one help me out to learn the DB in SQL server and the Dataset in vb.net... Well i m very keen to learn it.... can u ppl show some ways for this.... And another one thing i hav SQL server 2008 and vb.net 2005... If u ppl have some sample programs then plz give me.... or wht ways u know suggest me...

Regards
Prity

[jmcilhinney]

Follow the CodeBank link in my signature and check out my threads on an explanation of ADO.NET Data Containers and also Retrieving And Saving Data In Databases.

[Prity]

hi
i am unable to find it....i got u r signature ther i clicked but not getting it... can u paste the link here, please...

Regards
Prity

Follow the CodeBank link in my signature and check out my threads on an explanation of ADO.NET Data Containers and also Retrieving And Saving Data In Databases.

[jmcilhinney]

Try a bit harder. There's a link in my signature to a list of all my VB.NET CodeBank submissions. I've told you which ones to look at, so just look down the list until you find those and click the links. If you want to be able to develop software then you'll need to be able to follow a few links in a web page.