asp.net实例代码之DataGrid数据编辑
本文导语: asp.net datagrid控件的例子，演示了datagrid控件中数据编辑的方法。 代码： 代码示例: Sub Page_Load(Sender As Object, E As EventArgs) Dim strConnection As String Dim strSQL As String Dim objDataSet As New DataSet() ...
asp.net datagrid控件的例子，演示了datagrid控件中数据编辑的方法。
代码：
Sub Page_Load(Sender As Object, E As EventArgs)
Dim strConnection As String
Dim strSQL As String
Dim objDataSet As New DataSet()
Dim objConnection As OleDbConnection
Dim objAdapter As OleDbDataAdapter
strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=C:Northwind.mdb"
strSQL = "SELECT FirstName, LastName FROM Employees;"
objConnection = New OledbConnection(strConnection)
objAdapter = New OledbDataAdapter(strSQL, objConnection)
objAdapter.Fill(objDataSet, "Employees")
dgNameList1.DataSource = objDataSet.Tables("Employees").DefaultView
dgNameList1.DataBind()
End Sub
在datagrid控件中编辑数据
Original Data
Data with new Row
Data with edited Row
Data with deleted Row
您可能感兴趣的文章:
本站(WWW.)站内文章除注明原创外，均为转载、整理或搜集自网络。欢迎任何形式的转载，转载请注明出处。