.NET开发

本类阅读TOP10

·NHibernate快速指南(翻译)
·vs.net 2005中文版下载地址收藏
·【小技巧】一个判断session是否过期的小技巧
·VB/ASP 调用 SQL Server 的存储过程
·?dos下编译.net程序找不到csc.exe文件
·通过Web Services上传和下载文件
·学习笔记(补)《.NET框架程序设计(修订版)》--目录
·VB.NET实现DirectDraw9 (2) 动画
·VB.NET实现DirectDraw9 (1) 托管的DDraw
·建站框架规范书之——文件命名

分类导航
VC语言Delphi
VB语言ASP
PerlJava
Script数据库
其他语言游戏开发
文件格式网站制作
软件工程.NET开发
AddNew Method Example

作者:未知 来源:月光软件站 加入时间:2005-6-5 月光软件站

'This example uses the AddNew method to create a new record with the specified 'name. The AddName function is required for this procedure to run.

Sub AddNewX()

 Dim dbsNorthwind As Database
 Dim rstEmployees As Recordset
 Dim strFirstName As String
 Dim strLastName As String

 Set dbsNorthwind = OpenDatabase("Northwind.mdb")
 Set rstEmployees = _
  dbsNorthwind.OpenRecordset("Employees", dbOpenDynaset)

 ' Get data from the user.
 strFirstName = Trim(InputBox( _
  "Enter first name:"))
 strLastName = Trim(InputBox( _
  "Enter last name:"))

 ' Proceed only if the user actually entered something

' for both the first and last names.
 If strFirstName <> "" and strLastName <> "" Then

  ' Call the function that adds the record.
  AddName rstEmployees, strFirstName, strLastName

  ' Show the newly added data.
  With rstEmployees
   Debug.Print "New record: " & !FirstName & _
    " " & !LastName
   ' Delete new record because this is a demonstration.
   .Delete
  End With

 Else
  Debug.Print _
   "You must input a string for first and last name!"

End If

 rstEmployees.Close
 dbsNorthwind.Close

End Sub

Function AddName(rstTemp As Recordset, _
 strFirst As String, strLast As String)

 ' Adds a new record to a Recordset using the data passed
 ' by the calling procedure. The new record is then made
 ' the current record.
 With rstTemp
  .AddNew
  !FirstName = strFirst
  !LastName = strLast
  .Update
  .Bookmark = .LastModified
 End With

End Function




相关文章

相关软件