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