Search - recordset

Search - recordset - List

[ADO-ODBC] arsdb_src.zip DL : 0: 作者自己写的个Database和RecordSet类
Date : 2025-07-08 Size : 18.74kb User :
[ADO-ODBC] querydef.zip DL : 0: 使用ODBC实现的一个动态RecordSet
Date : 2025-07-08 Size : 85.69kb User :
[Other resource] 作者自己写的个Database和RecordSet类 DL : 0: 自己编写的一个数据库，连接的Database和RecordSet类-themselves prepared a database connectivity and Database category RecordSet
Date : 2008-10-13 Size : 19.04kb User : 张小强
[ComboBox] vsprintvsflex8 DL : 2: 用 vsFlexGrid 时，如果用 Add 方法逐个添加数据，跟在 Excel 中用Range()设置单元格的数据一样的慢，所以需要有些技巧，举例来说：在Excel中填写一个数据区域，可以将将要填写进去的数据按单元格的排列事先加入相应的制表符以及回车符号，组合成一个大的字符串，然后帖进去，会很快。 VsFlexGrid 在需要填充的数据多时会比较慢，同样条件的前提下，VB会明显快些！数据加载速度慢可以通过直接绑定ADO的记录集，那样会很快，只是显得没有个性。比如从后台取回的数据是个数字，在前台需要根据这个数字分情况来显示各种不同的字符，如果用RecordSet我不知道怎么搞了。。 vsFlexGrid 的慢是一个问题，也许还比较好避免，也许这并不是他本身的问题，好像很多的控件只要是逐个ADD的都不会快多少，除非用直接绑定！更麻烦的还是从vsFlexGrid到vsPrinter的报表显示显得有点牵强~~，不过常规的报表都还可以应付，象我们的工资明细表、汇总表、储备金汇总、储备金明细、计件工资、花名册、考勤报表乃至工资条等都可以用vsFlexGrid解决，而且能做出比较漂亮的效果，尤其那个表格的合并效果，以及所见所得。。。 -with vsFlexGrid, when used individually Add method to add data with Excel using Range () set up the cell for the same data slow, there is a need in some skills, for example : Excel to fill in a data area can be filled out to be of the data into cells with the prior joining the corresponding tabs and carriage return symbols, as a large portfolio of strings, and then into TIE will soon. VsFlexGrid need to fill in the data for some time will be relatively slow and the same conditions, under the premise of VB will be significantly faster! Data loading slow through direct bonding ADO record set, as it will soon, it is not personality. For example, to recover from the background information is in the number of prospects according to the breakdown of the figures to show a variety of characters, i
Date : 2008-10-13 Size : 588.23kb User : 胡先生
[ASP] ProductSearch133 DL : 0: <％@ LANGUAGE=\"VBSCRIPT\" ％>  <％ ProductClass_2=request(\"ProductClass_2\") set rs=server.createobject(\"adodb.recordset\") sqltext=\"select * from Product\" if request(\"Product_Name\")<>\"\" then sqltext=sqltext &\" where Product_Name like ％\"& request(\"Product_Name\") &\"％ \" else sqltext=sqltext &\" where Product_Name like ％\"& \"\" &\"％ \" end if if request(\"Product_Class\")<>\"\" then sqltext=sqltext &\" and Class_1 like ％\"& request(\"Product_Class\") &\"％ \" end if
Date : 2008-10-13 Size : 3.45kb User : 金立犇
[ASP] Reg_User_22 DL : 0: <％@ LANGUAGE=\"VBSCRIPT\" ％>  <％ set rs=server.createobject(\"adodb.recordset\") sqltext=\"select * from RegUser where UserId= \" & request.form(\"uid\") & \" \" rs.open sqltext,co
Date : 2008-10-13 Size : 5.94kb User : 金立犇
[Other] MicrosoftJetSQL_reference DL : 0: 使用 SQL 合计函数你可以确定数据组的各种统计。你可以把这些函数用于查询和合计表达式，条件是在具备 SQL特性的 QueryDef对象中或在创建基于SQL查询的 Recordset对象时
Date : 2008-10-13 Size : 201.71kb User : zy
[Other resource] Store_proc_ado_recordset DL : 0: 利用ADO的recordset对象执行带参数的存储过程，并返回记录集的例子。带数据库文件。有详尽说明
Date : 2008-10-13 Size : 325.17kb User : 狼尾草
[JSP/Java] ydm DL : 0: 我对mo安装目录下VB的MoView例子的frmIdentify窗体修改，其中添加了1个label空件组(10个)，1个text控件组(10个)，2个command(Edit 、Save)按钮,要实现的功能是对读入的图形文件的相关记录的指定字段的属性值，并能保存，用了Recordset对象的Edit函数、Update函数，
Date : 2008-10-13 Size : 3.35kb User : haogood
[Other resource] SQL DL : 0: 使用 SQL 合计函数你可以确定数据组的各种统计。你可以把这些函数用于查询和合计表达式，条件是在具备 SQL特性的 QueryDef对象中或在创建基于SQL查询的 Recordset对象时。
Date : 2008-10-13 Size : 202.1kb User : 靳海峰
[WEB Code] ADO DL : 0: vc++中使用ado技术的一套模板，十分好用，包括connection，和recordset，避免了重复输入代码
Date : 2008-10-13 Size : 76.89kb User : liuyiyu
[CSharp] MapXwasusedincsharp DL : 0: 实现mapx从数据库读取数据形成新图层分为两个问题：1.mapx从数据库读取数据形成新图层；2.将datatable转换为ado的recordset
Date : 2008-10-13 Size : 5.04kb User : 齐杰
[Button control] oledb-3 DL : 0: Adding bookmark functionality is relatively easy and it enables our ADO recordset to be used with a greater number of data bound controls. 给DataBound控件增加书签功能(52KB)
Date : 2008-10-13 Size : 51.95kb User : 张玉祥
[SQL Server] 读写SQL中的image字段.zip DL : 0: Private Declare Function DeleteFile Lib "kernel32" Alias "DeleteFileA" (ByVal lpFileName As String) As Long '************************************************************* Public Function ImportPhoto(sPicFile As String, sEmpID As String) As String Dim rcsPic As ADODB.Recordset Dim sMax As String Dim sInsertPic As String Dim rcsTemp As New Recordset Dim sTempSQL As String If Trim(sPicFile) = "" Then Exit Function On Error GoTo ErrorImportPhoto Set rcsPic = New ADODB.Recordset rcsPic.CursorType = adOpenKeyset rcsPic.LockType = adLockOptimistic ' rcsPic.Open "T_PPICTURE ", AstDbCnt, , , adCmdTable 'astdbcnt 替换为你连接方式 Set mstream = New ADODB.Stream mstream.Type = adTypeBinary mstream.Open mstream.LoadFromFile sPicFile rcsPic.AddNew rcsPic.Fields("PERS").Value = sEmpID rcsPic.Fields("PIC").Value = mstream.Read rcsPic.Update mstream.Close Set mstream = Nothing rcsPic.Close Set rcsPic = Nothing Exit Function ErrorImportPhoto: ImportPhoto = "FALSE" End Function '注意要将 AstDbCnt 替换为你的oracle 连接 Public Function DisplayPhoto(oPicture As PictureBox, sPicID As String) Dim rcsDisplay As ADODB.Recordset Set rcsDisplay = New ADODB.Recordset Dim mstream As ADODB.Stream Dim mc0 As String rcsDisplay.Open "Select * from T_PPICTURE where PERS = '" & sPicID & "'", AstDbCnt, adOpenKeyset, adLockOptimistic If rcsDisplay.EOF Then oPicture.Picture = LoadPicture() Exit Function End If If IsNull(rcsDisplay.Fields("PIC").Value) Then oPicture.Picture = LoadPicture() Exit Function End If Set mstream = New ADODB.Stream mstream.Type = adTypeBinary mstream.Open mstream.Write rcsDisplay.Fields("PIC").Value strclose = App.Path & "\AstPhoto_temp" DeleteFile (strclose) mstream.SaveToFile strclose mstream.Close Set mstream = Nothing rcsDisplay.Close Set rcsDisplay = Nothing oPicture.Picture = LoadPicture(strclose) End Function Private Sub Command1_Click() Set cn = New ADODB.Connection cn.Open "Provider=SQLOLEDB;data Source=IWP2;Initial Catalog=T213;User Id=sa;Password=sql123" Set rs = New ADODB.Recordset rs.Open "Select * from QB_T213PMPD where DT=2006080818", cn, adOpenKeyset, adLockOptimistic Set mstream = New ADODB.Stream mstream.Type = adTypeBinary mstream.Open mstream.Write rs.Fields("MPI").Value mstream.SaveToFile "P:\T213_data\ShowMPI\T213_3.mpi", adSaveCreateOverWrite rs.Close cn.Close End Sub Private Sub Command2_Click() Set cn = New ADODB.Connection cn.Open "Provider=SQLOLEDB;data Source=;Initial Catalog=pubs;User Id=;Password=" Set rs = New ADODB.Recordset rs.Open "Select * from pub_info", cn, adOpenKeyset, adLockOptimistic Set mstream = New ADODB.Stream mstream.Type = adTypeBinary mstream.Open mstream.LoadFromFile "" rs.Fields("logo").Value = mstream.Read rs.Update rs.Close cn.Close End Sub
Date : 2009-04-21 Size : 3.05kb User : wuzhiyong_130@163.com
[ADO-ODBC] querydef DL : 0: 使用ODBC实现的一个动态RecordSet-Using ODBC to implement an dynamic recordset
Date : 2025-07-08 Size : 86kb User : 站长
[SQL Server] 作者自己写的个Database和RecordSet类 DL : 0: 自己编写的一个数据库，连接的Database和RecordSet类-themselves prepared a database connectivity and Database category RecordSet
Date : 2025-07-08 Size : 19kb User : 张小强
[SQL Server] Store_proc_ado_recordset DL : 0: 利用ADO的recordset对象执行带参数的存储过程，并返回记录集的例子。带数据库文件。有详尽说明-ADO
Date : 2025-07-08 Size : 325kb User : 狼尾草
[WEB Code] ADO DL : 0: vc++中使用ado技术的一套模板，十分好用，包括connection，和recordset，避免了重复输入代码-vc++ technology used in ado a template, very easy to use, including the connection, and the recordset, to avoid duplication of input code
Date : 2025-07-08 Size : 77kb User : liuyiyu
[SQL Server] clsADODB DL : 0: Type of communication with SQL server... Class that use asyncronouns recordset, commands and connections-Type of communication with SQL server... Class that use asyncronouns recordset, commands and connections...
Date : 2025-07-08 Size : 8kb User : Daniel
[Other Databases] recordset-combo DL : 0: recordset and combo box
Date : 2025-07-08 Size : 16kb User : nafis

« 12 3 4 5 6 »