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