如何在ASP.NET中顯示數(shù)據(jù)庫(kù)中的數(shù)據(jù)
發(fā)表時(shí)間：2024-06-19 來(lái)源：明輝站整理相關(guān)軟件相關(guān)文章人氣：
[摘要]第一步:從左邊工具欄中拖一個(gè)datagrid到頁(yè)面上,ID為datagrid1 .第二步:雙擊空白處,進(jìn)入代碼編寫(xiě)窗口.找到Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handl...
第一步:從左邊工具欄中拖一個(gè)datagrid到頁(yè)面上,ID為datagrid1 .
第二步:雙擊空白處,進(jìn)入代碼編寫(xiě)窗口.找到
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
在其后加入如下代碼:
Dim strmycon As String = "server=mis04;user id=sa;password=little;database=humanresource"
Dim strmycom As String = "select top 10 * 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()
第三步
