This blog defines database data in an ASP.NET GridView control.

Data Binding in GridView

1. Create an ASP.NET Web application

2. Drag and drop a SQL Data Source GridView data control on page.

Database Table

create table usertable1

(

UserId int identity(1,1),

FirstName varchar(50),

LastName varchar(30),

Age varchar(30)

)

Go

insert into usertable1 values('rohatash','Kumar','23')

go

insert into usertable1 values( 'monu','rathor','20')

go

insert into usertable1 values( 'rahul','sharma','24')

go

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