GridView in ASP.NET

insert into usertable1 values('ram','singh','26')

Once you have drag and drop gridview control on the form and double click on the form and add the following code.

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

If Not Page.IsPostBack Then

Binddata()

End If

End Sub

Public Sub Binddata()

Dim strcon As String = "Data Source=.;uid=sa;pwd=Password$2;database=master"

Dim con As New SqlConnection(strcon)

Dim retriveUserPass As String = "select * from usertable1"

Dim com As New SqlCommand(retriveUserPass, con)

con.Open()

com.ExecuteNonQuery()

Dim dp As New SqlDataAdapter(com)

Dim st As New DataSet("usertable1")

dp.Fill(st, "usertable")

GridView2.DataSource = st

GridView2.DataBind()

con.Close()

End Sub