我用ADO控件连接数据库,实现对数据库中表的删除,插入等操作,要插入的内容从另一个窗口中的TEXT组件中输入,请问怎么传到ADO控件中并实现插入我的插入方法代码如下:
Private Sub Form_Load()
Adodc1.Recordset.AddNew
Adodc1.Recordset("RoomNO") = ?????
Adodc1.Recordset("RoomPosition") = ???
Adodc1.Recordset("RoomState") = ????
Adodc1.Recordset("RoomType") = ?????
Adodc1.Recordset.Update
End Sub
Private Sub Form_Load()
Adodc1.Recordset.AddNew
Adodc1.Recordset("RoomNO") = ?????
Adodc1.Recordset("RoomPosition") = ???
Adodc1.Recordset("RoomState") = ????
Adodc1.Recordset("RoomType") = ?????
Adodc1.Recordset.Update
End Sub
Private Sub Form_Load()
Adodc1.Recordset.AddNew
Adodc1.Recordset("RoomNO") = ?????
Adodc1.Recordset("RoomPosition") = ???
Adodc1.Recordset("RoomState") = ????
Adodc1.Recordset("RoomType") = ?????
Adodc1.Recordset.Update
End Sub假如第一个窗口为FrmGrid另一个窗Frmdatain .RoomNO,RoomPosition,RoomState,RoomType的输入框分别为:text1,...text4 怎么把TEXT中的数据返回.
Adodc1.Recordset("RoomNO") = text1.text
Adodc1.Recordset("RoomPosition") =text2.text
Adodc1.Recordset("RoomState") =text3.text
Adodc1.Recordset("RoomType") =text4.text
Adodc1.Recordset.Update
Adodc1.Recordset("RoomNO") = Frmdatain.Text1.Text
Adodc1.Recordset("RoomPosition") = Frmdatain.Text2.Text
Adodc1.Recordset("RoomState") = Frmdatain.Text3.Text
Adodc1.Recordset("RoomType") = Frmdatain.Text4.text
一般方式
FrmGrid中點<添加>時
Frmdatain.show 1,me
在Frmdatain中,輸入完信息后,點<保存>
Private Sub CmdSave_Click()
With FrmGrid
.Adodc1.Recordset.AddNew
.Adodc1.Recordset("RoomNO") = text1.text
.Adodc1.Recordset("RoomPosition") =text2.text
.Adodc1.Recordset("RoomState") =text3.text
.Adodc1.Recordset("RoomType") =text4.text
.Adodc1.Recordset.Update
End With
End Sub
Adodc1.Recordset.AddNew
Adodc1.Recordset("RoomNO") = Frmdatain.Text1.Text
Adodc1.Recordset("RoomPosition") = Frmdatain.Text2.Text
Adodc1.Recordset("RoomState") = Frmdatain.Text3.Text
Adodc1.Recordset("RoomType") = Frmdatain.Text4.textAdodc1.Recordset.Update
End Sub
"没有该记录"是何故???
Private Sub Command2_Click()
Data1.Recordset.FindFirst "RoomNO='Text5.Text'"
If Data1.Recordset.NoMatch Then
MsgBox "没有该记录"
Else
Data1.Recordset("RoomPosition") = Text6.Text
Data1.Recordset("roomstate") = Text7.Text
Data1.Recordset("roomtype") = Text8.Text
Data1.Recordset.Update
End If
End Sub
Data1.Recordset.FindFirst "RoomNO = '" & Text5.Text & "'"
If Data1.Recordset.NoMatch Then
MsgBox "没有该记录"
Else
Data1.Recordset("RoomPosition") = Text6.Text
Data1.Recordset("roomstate") = Text7.Text
Data1.Recordset("roomtype") = Text8.Text
Data1.Recordset.Update
End If
End Sub
recordset An object variable that represents an existing dynaset- or snapshot-type Recordset object.
criteria A String used to locate the record. It is like the WHERE clause in an SQL statement, but without the word WHERE.