databasing with sql server in vb.net

[abhay1234]

ok i know connecting access. i want to learn database connectivity using sql server in vb.net.

How do i create a table in sql server in vb.net visual studio i dont have sql server installed in my pc

also performing database manipulation in windows application(i have been doing it in console)

so far i have this

Module Module1
    Dim sConnection As String = "Password=password;Persist Security Info=True;User ID=sa;Initial Catalog=CD;Data Source=(local)"
    Sub Main()
        Dim objConn As New System.Data.SqlClient.SqlConnection(sConnection)
        Try
            objConn.Open()
        Catch myException As System.Exception
            Console.WriteLine(myException.Message)
        End Try
        Console.ReadLine()

    End Sub
End Module