Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.SqlTypes
Imprits System.Web.UI.WebControlsPublic Class WebForm1
Inherits System.Web.UI.Page Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'在此处放置初始化页的用户代码
Dim grid as DataGrid = new DataGrid()
Page.Controls[1].Controls.Add(grid)'动态在页面上添加一个DataGrid控件
If Not Page.IsPostBack Then
Dim cnSQL As SqlConnection
Dim daSQL As SqlDataAdapter
Dim dscourses As New DataSet()
cnSQL = New SqlConnection("server=localhost;uid=sa;pwd=;database=pubs;")
cnSQL.Open() daSQL = New SqlDataAdapter("select * from authors", cnSQL)
'cmdSql = New SqlCommandBuilder(daSQL)
daSQL.Fill(dscourses, "authors")
' dscourses.Tables("authors").Rows(0).Item("city") = 0 grid.DataSource = dscourses.Tables("authors").DefaultView grid.DataBind()
'daSQL.Update(dscourses, "authors")
cnSQL.Close() End If
End Sub
End Class
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.SqlTypes
Imprits System.Web.UI.WebControlsPublic Class WebForm1
Inherits System.Web.UI.Page Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'在此处放置初始化页的用户代码
Dim grid as DataGrid = new DataGrid()
Page.Controls[1].Controls.Add(grid)'动态在页面上添加一个DataGrid控件
If Not Page.IsPostBack Then
Dim cnSQL As SqlConnection
Dim daSQL As SqlDataAdapter
Dim dscourses As New DataSet()
cnSQL = New SqlConnection("server=localhost;uid=sa;pwd=;database=pubs;")
cnSQL.Open() daSQL = New SqlDataAdapter("select * from authors", cnSQL)
'cmdSql = New SqlCommandBuilder(daSQL)
daSQL.Fill(dscourses, "authors")
' dscourses.Tables("authors").Rows(0).Item("city") = 0 grid.DataSource = dscourses.Tables("authors").DefaultView grid.DataBind()
'daSQL.Update(dscourses, "authors")
cnSQL.Close() End If
End Sub
End Class
Imports System.Data.SqlClient相当于
<%@ Import Namespace="System.Data.SqlClient" %>,无论哪种,写一次就可以了;老版本的<%@ Import Namespace="System.Data.SQL" %>现在是<%@ Import Namespace="System.Data.SqlClient" %>,同样,把代码写在webform1.aspx的html中,和把代码写在webform1.aspx.vb中没有区别,唯一的区别就是分开更清晰、思路更明确