How To Connect To SQL Database, Create Tables

Hi All, 1st of all happy New Year to all asp.net forum members

    I am new at asp.net. I want to design a website
using asp.net as frontend and sql database as backend. I am able to
connect and add,update as well delete records when I use MsAcess and
Asp.net using the following connection strings...

**********

sub Page_Load

dim dbconn,sql,dbcomm,dbread

dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" & server.mappath("/database/northwind.mdb"))

dbconn.Open()

sql="SELECT * FROM customers where city LIKE 'Berlin' order by city ASC"

dbcomm=New OleDbCommand(sql,dbconn)

dbread=dbcomm.ExecuteReader()

customers.DataSource=dbread

customers.DataBind()

dbread.Close()

dbconn.Close()

end sub

**********



But when I try to connect to sql database using the following connection strings I am unable to do so...



**************

SqlConnection myConnection = new SqlConnection("server=PLATINUMVSdotNET;database=pubs;Trusted_Connection=yes");

        SqlDataAdapter myCommand = new SqlDataAdapter(" * from Authors", myConnection);



        DataSet ds = new DataSet();

        myCommand.Fill(ds, "Authors");



        MyDataGrid.DataSource=ds.Tables["Authors"].DefaultView;

        MyDataGrid.DataBind();



**************

I have written the servername as "PLATINUMVSdotNET" because when I
installed SQL SERVER 2000 I found a tray icon where the server name was
displaying the same (my computer name is PLATINUM).

When I used webmatrix I enterd the same server name and  windows
authentication I was able to create a database but How to create
table...



Please help me out

Thanks in advance...