adodb.recordset.recordcount

sdyqingdao 2001-07-20 04:00:23

how to get it at run time?
&,what is link table?

...全文

104 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

sdyqingdao 2002-02-04

打赏
举报

结了

wweilinux 2002-01-31

打赏
举报

通过访问注册表，写到run字键中就可开机自动运行。要链接表，先要建一个表，然后将ado控件的database属性设为你建的数据库名，recordsouce属性设为你建的表名。recordset是表中记录集属性，可通过数组对表中字段进行操作。recordcount则是统计表中字段数。

jett 2002-01-31

打赏
举报

什么意思？

ferrytang 2002-01-31

打赏
举报

我来~~~~~
你要问什么?

sdyqingdao 2002-01-31

打赏
举报

谁来留言，让我结贴

vb学生管理系统源代码部分代码 Public UserName As String Public txtSQL As String 'use to store record SQLsentence Public dream As ADODB.Recordset 'use to store record object Public Msgtext As String '用来存放返回信息 Public OK As Boolean ' 'Public db As String Public Sub highlight() With Screen.ActiveForm If (TypeOf .ActiveControl Is TextBox) Then .ActiveControl.SelStart = 0 .ActiveControl.SelLength = Len(.ActiveControl) End If End With End Sub Sub Main() 'Dim Login As New Login 'Login.Show vbModal 'f Not Login.OK Then 'Login Failed so exit app ' End 'End If 'Unload studentmdi ' Set login = New login login.Show End Sub Public Function connectstring() As String connectstring = "Provider=Microsoft.jet.OLEDB.3.51;Data source=f:\schoolgroup\school.mdb" End Function Public Function ExecuteSQL(ByVal SQL As String, Msgstring As String) As ADODB.Recordset Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Dim sTokens() As String On Error GoTo ExecuteSQL_Error sTokens = Split(SQL) Set cnn = New ADODB.Connection cnn.Open connectstring If InStr("INSERT,DELETE,UPDATE", UCase$(sTokens(0))) Then cnn.ExecuteSQL Msgstring = sTokens(0) & "query successful" Else Set rst = New ADODB.Recordset rst.Open Trim(SQL), cnn, adOpenKeyset, adLockOptimistic Set ExecuteSQL = rst Msgstring = "查询到" & rst.RecordCount & " 条记录" End If executeSQL_exit: Set rst = Nothing Set cnn = Nothing Exit Function ExecuteSQL_Error: Msgstring = "查询错误：" & err.Description Resume executeSQL_exit End Function Public Function Testtxt(txt As String) As Boolean If Trim(txt) = "" Then Testtxt = False Else Testtxt = True End If End Function

SQL+VB做成的licit Public gUserName As String Public gUserKind As String Public gEmployeeId As String Public gLoginSucceeded As Boolean Public Const BLUE = &HFF0000 Public Const WHITE = &H80000005 Sub Main() Dim fLogin As New frmLogin '启动登录窗体 fLogin.Show vbModal '装入并显示模式窗体。 If Not gLoginSucceeded Then MsgBox "系统启动失败,请重试!", vbOKOnly + vbExclamation, "警告" End If Unload fLogin End Sub Public Function ConnectString() As String ConnectString = "Provider=SQLOLEDB.1;Password=sa;User ID=sa;Initial Catalog=DBManPower;Data Source=127.0.0.1;" End Function Public Function ExecuteSQL(ByVal SQL As String, rst As ADODB.Recordset, _ Optional enableWrite As Boolean = True) As Boolean Dim con As ADODB.Connection Dim sTokens() As String On Error GoTo Execute_Error sTokens = Split(SQL) Set con = New ADODB.Connection con.Open ConnectString '打开数据库 Set rst = New ADODB.Recordset If enableWrite Then '读写方式 rst.Open Trim$(SQL), con, adOpenStatic, adLockOptimistic Else '只读方式 rst.Open Trim$(SQL), con, adOpenStatic, adLockReadOnly End If ExecuteSQL = True Exit Function Execute_Error: ExecuteSQL = False Exit Function End Function Public Function DBExist(ByVal SQL As String) As Integer Dim con As ADODB.Connection Dim sTokens() As String Dim flag As String Dim rst As ADODB.Recordset sTokens = Split(SQL) Set con = New ADODB.Connection con.Open ConnectString flag = ExecuteSQL(SQL, rst, False) '判断该记录是否存在 If rst.RecordCount <> 0 Then DBExist = rst.RecordCount Else DBExist = 0 End If con.Close End Function Public Function txtIsNull(txt As TextBox) As Boolean If Trim(txt.Text) = "" Then txtIsNull = True txt.SetFocus txt.BackColor = BLUE Else txtIsNull = False End If

1.Com链接，ADODB.Connection 复制代码代码如下: $conn = new Com(“ADODB.Connection”); //实例化一个Connection对象 $connstr = “provider=sqloledb;datasource=.;uid=sa;pwd=123456;database=jnold;”; $conn->Open($connstr); $rs = new Com(“ADODB.Recordset”); //实例化一个Recordcount对象 $rs->Open(‘select * from News where bigclassid = 5

四轨直销系统(四四复制)带计算源码无加密后台地址：jzzgg.asp 帐号密码：admin 0 then if isnull(HyWeekRs("MaxComputeWeek")) then MaxComputeWeek=1 else MaxComputeWeek=HyWeekRs("MaxComputeWeek")+1 end if else MaxComputeWeek=1 end if set HyWeekRs=nothing set HyExcelRs=nothing set HyExcelRs=server.CreateObject("adodb.recordset") sql = "SELECT HyNumber,isfour FROM HyClub where IsApproved=true " HyExcelRs.Open sql,conn,1,1 j=HyExcelRs.RecordCount if j>0 then while (not HyExcelRs.eof) set ComputeRs=server.CreateObject("adodb.recordset") sql="" HyNumber=HyExcelRs("HyNumber") isfour=HyExcelRs("isfour") set HyRs888=server.CreateObject("adodb.recordset") sql = "select HyManageTotal_Left from HyMoneyAccount where HyNumber ='" & HyNumber & "'" HyRs888.Open sql,conn,1,1 if HyRs888.recordcount=0 then left_old=0 else left_old=HyRs888("HyManageTotal_Left") if left_old="" or isnull(left_old) then left_old=0 end if end if set HyRs888=nothing LeftCount=0 MiddleCount=0 MiddleLCount=0 RightCount=0 If GetHyParentNumberCount(HyNumber)=4 Then LeftCount=GetLeftCountLevel(HyNumber,1,1,8) MiddleCount=GetMiddleCountLevel(HyNumber,1,1,8) MiddleLCount=GetMiddleLCountLevel(HyNumber,1,1,8) RightCount=GetRightCountLevel(HyNumber,1,1,8) End if 'response.write LeftCount&"|"&MiddleCount;&"|"&RightCount;&"" TeamManageMoney=0 Temp

VB基础类

7,763

社区成员

197,609

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章