GridView更新,编辑,删除

1.创建数据表
USE NorthWind
GO

--创建人事表
CREATE TABLE HmanHant
(
 Empno varchar(9) primary key not null,
 EmpNM nvarchar(10) not null,
 IdentifyNO nvarchar(17) null,
 BirthYMD varchar(8) null,
 Oaddr nvarchar(50) null
)

--远程插入人员表
BEGIN TRAN
INSERT INTO Hmanhant(Empno,EmpNM,IdentifyNO,BirthYMD,Oaddr)
SELECT  EMPNO,CEMPNM,substring(RESNO,1,17),BIRTHYMD,OADDR
FROM [192.168.11.17].SY_PEOPLE.dbo.Hman200t
ROLLBACK TRAN

 

2.取得GridView编辑框的新值与旧值
 a.获取编辑框的旧值
vEmpNM = GridView1.Rows(e.RowIndex).Cells(0).Text.ToString().Trim()
 b.获取编辑框的新值
vEmpNM = CType(GridView1.Rows(e.RowIndex).Cells(0).Controls(0),TextBox).Text.ToString().Trim()

 

3.后台EditDefault.aspx.vb

Imports System.Data.SqlClient Imports System.Data.DataSet Partial Class EditDefault Inherits System.Web.UI.Page Dim sqlCon As SqlConnection Dim sqlCom As SqlCommand Const strCon As String = "Data Source=192.168.11.53;Database=NorthWind;Uid=sa;Pwd=m1erpsql;" Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not IsPostBack Then Bind() End If End Sub '绑定数据集 Private Sub Bind() Dim strSql As String Dim myda As New SqlDataAdapter Dim myds As New Data.DataSet strSql = "SELECT Empno,EmpNM,IdentifyNO,BirthYMD,Oaddr FROM NorthWind..HmanHant Order By empno ASC&