我本来就把源程序贴在上面的啊,现重贴下Dim con As New ADODB.Connection Dim rs As New ADODB.Recordset Dim i As Integer Private Sub Command1_Click() '连接数据库 con.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=sa;Initial Catalog=db_SJK07" '打开记录集 rs.Open "select * from 作者 ", con, adOpenKeyset, adLockOptimistic '修改字段信息 For i = 1 To 4 rs.Fields(i) = Trim(Text1(i).Text) Next i rs.Update MsgBox "修改数据成功", , "明日图书" '表格显示作者数据表 Set MSHFlexGrid1.DataSource = con.Execute("select * from 作者") rs.Close con.Close End Sub Private Sub Form_Load() con.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=sa;Initial Catalog=db_SJK07" Set MSHFlexGrid1.DataSource = con.Execute("select * from 作者 ") con.Close For i = 0 To 4 Text1(i).Text = "" Next End Sub Private Sub MSHFlexGrid1_RowColChange() con.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=sa;Initial Catalog=db_SJK07" rs.Open "select * from 作者 where 编号='" & MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 1) & "'", con, adOpenKeyset If rs.RecordCount > 0 Then For i = 0 To 4 Text1(i).Text = rs.Fields(i) Next End If rs.Close con.Close End Sub Private Sub Command2_Click() Unload Me End Sub
你的意思应该是把 text(i)的内容修改到当前记录,改动试下:Private Sub Command1_Click() if MSHFlexGrid1.ROW = Then Exit sub con.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=sa;Initial Catalog=db_SJK07" rs.Open "select * from 作者 where 编号='" & MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 1) & "'", con, adOpenKeyset If rs.RecordCount > 0 Then For i = 1 To 4 rs.Fields(i) = Trim(Text1(i).Text) Next i rs.Update MsgBox "修改数据成功", , "明日图书" '表格显示作者数据表 Set MSHFlexGrid1.DataSource = con.Execute("select * from 作者") rs.Close con.Close End Sub
rowindex, colindex这两个参数是不是没有弄对?
rowindex, colindex这两个参数是不是没有弄对?
Dim rs As New ADODB.Recordset
Dim i As Integer
Private Sub Command1_Click()
'连接数据库
con.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=sa;Initial Catalog=db_SJK07"
'打开记录集
rs.Open "select * from 作者 ", con, adOpenKeyset, adLockOptimistic
'修改字段信息
For i = 1 To 4
rs.Fields(i) = Trim(Text1(i).Text)
Next i
rs.Update
MsgBox "修改数据成功", , "明日图书"
'表格显示作者数据表
Set MSHFlexGrid1.DataSource = con.Execute("select * from 作者")
rs.Close
con.Close
End Sub
Private Sub Form_Load()
con.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=sa;Initial Catalog=db_SJK07"
Set MSHFlexGrid1.DataSource = con.Execute("select * from 作者 ")
con.Close
For i = 0 To 4
Text1(i).Text = ""
Next
End Sub
Private Sub MSHFlexGrid1_RowColChange()
con.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=sa;Initial Catalog=db_SJK07"
rs.Open "select * from 作者 where 编号='" & MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 1) & "'", con, adOpenKeyset
If rs.RecordCount > 0 Then
For i = 0 To 4
Text1(i).Text = rs.Fields(i)
Next
End If
rs.Close
con.Close
End Sub
Private Sub Command2_Click()
Unload Me
End Sub
if MSHFlexGrid1.ROW = Then Exit sub
con.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=sa;Initial Catalog=db_SJK07"
rs.Open "select * from 作者 where 编号='" & MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 1) & "'", con, adOpenKeyset
If rs.RecordCount > 0 Then
For i = 1 To 4
rs.Fields(i) = Trim(Text1(i).Text)
Next i
rs.Update
MsgBox "修改数据成功", , "明日图书"
'表格显示作者数据表
Set MSHFlexGrid1.DataSource = con.Execute("select * from 作者")
rs.Close
con.Close
End Sub
if MSHFlexGrid1.ROW = 0 Then Exit sub