How to display data from a database in asp.net

asp.net| Data | database | Show the first step: Drag a DataGrid from the left toolbar to the page with ID DataGrid1.

The second step: double-click the blank space, enter the Code writing window. Find

Private Sub Page_Load (ByVal sender as System.Object, ByVal e as System.EventArgs) Handles MyBase.Load

Then add the following code:

Dim Strmycon as String = "Server=mis04;user Id=sa;password=little;database=humanresource"

Dim strmycom as String = "SELECT top * from Tbl_user"

Dim Mycon as New sqlclient.sqlconnection (Strmycon)

Dim mycom as New sqlclient.sqlcommand (strmycom, mycon)

Mycon. Open ()

Dim myreader as Sqlclient.sqldatareader

myreader = mycom. ExecuteReader ()

DataGrid1.DataSource = myreader

Datagrid1.databind ()

Mycon. Close ()

Step three, run F5