关于datagrid控件记录选择和操作的问题
小弟最近刚学习数据库 用SQL SERVER+VB试着做个简单的程序在使用中遇到了一个问题
比如有两张表GQ和DB,一个记录(有多个字段)在GQ表中,现在我通过对GQ表进行查询找到并用datagrid控件显示出了这个记录,我现在想将GQ表中的这个记录通过选定然后添加到DB表中,请各位高手指点一下该如何实现~不胜感激~~~
--------------------编程问答-------------------- 自己顶下~ --------------------编程问答-------------------- 帮楼主顶一下。 --------------------编程问答-------------------- Dim rs As New ADODB.Recordset
Private Sub Command1_Click()
Dim sql As String
Dim name As String
Dim age As String
Dim notes As String
Dim rs1 As New ADODB.Recordset
name = rs.Fields("姓名")
age = rs.Fields("年龄")
notes = rs.Fields("备注")
rs1.CursorType = adOpenKeyset
rs1.LockType = adLockOptimistic
rs1.Open "DQ", conn, , , adCmdTable
rs1.AddNew
rs1.Fields!姓名 = name
rs1.Fields!年龄 = age
rs1.Fields!备注 = notes
rs1.Update
rs1.Close
End Sub
Private Sub Form_Load()
Dim sql As String
sql = "select * from CQ"
rs.CursorLocation = adUseClient
rs.Open sql, conn, adOpenKeyset, adLockOptimistic
Set DataGrid1.DataSource = Nothing
Set DataGrid1.DataSource = rs
End Sub
补充:VB , 控件