Insert Data Into SQL SERVER EXPRESS Edition

I'm completely new to ASP.NET. I want to insert data to the SQL SERVER EXPRESS database.When the button clicks i want to add the details into database.This is the coding i did with online help.

Can you help me to do a good coding ad some error showing on my 7th line("connection.Open()")..

And can you advise me to do correct coding for how is get data from database and display it on web page.

Thanks in advance.And here is the coding i did to Insert data,

Imports System.Data.SqlClient

Partial Class _Default

Inherits System.Web.UI.Page

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim connection As New SqlConnection(" database=share")

Dim cmd As New SqlCommand("INSERT INTO sdetails (cid, cname, date, qty, pps)VALUES('" & txtcid.Text & "','" & txtcname.Text & "','" & txtdate.Text & "','" & txtqty.Text & "','" & txtpps.Text & "')", connection)

 

connection.Open()

connection.Close()

End Sub