getportals.com

how do i connect to a sql server database on godaddy in asp.net?

this is what i have so far:

Dim cn As New System.Data.SqlClient.SqlConnection("Data Source=whsql-v20.prod.mesa1.secureserver.net; Initial Catalog=janeric; User ID=janeric; Password='insertpassword';")<br/>
cn.Open()<br/>
Dim cmd As Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand("insert into products (id, name, price, description, count, pictureadd, artist, catergory) values ('1','nothing','5000.00','sdfasdf','1','lithographs/african lion.png','stobart','animal');", cn)<br/>
Dim sqlrdr As Data.SqlClient.SqlDataReader = cmd.ExecuteReader(Data.CommandBehavior.Default)<br/>
Dim adapter As New System.Data.SqlClient.SqlDataAdapter()
adapter.SelectCommand = New Data.SqlClient.SqlCommand("select * from products", cn)</br>
Dim ds As New Data.DataSet<br/>
adapter.Fill(ds)<br/>
datagrid1.DataSource = ds<br/>
datagrid1.DataBind()<br/>
cn.Close()<br/>
<br/>
<br/>