ADO
Parse ADO Recordset to Individual Excel Sheets
I\'m trying to take an ADO Recordset and then loop through it to parse individual rows to different worksheets within an Excel workboo开发者_运维知识库k. Unfortunately, as I step through my code, I ge[详细]
2023-03-12 00:39 分类：问答Howto use a GUID as an ADO query parameter using C++ ADO
Given a SQL Server database that uses uniqueidentifiers as primary key fields for the table I want to query and a GUID struct (included via rpc.h) that has the value of one of the entries in the table[详细]
2023-03-11 02:30 分类：问答Force CREATE PROC when table in the SQL does not exist yet (VB.NET)
I am converting a lot of projects from VB6 to VB.NET. Many of these projects use the DAO method CreateQueryDef, something ADO.NET does not. I know there is a way to replicate this method in ADOX using[详细]
2023-03-10 19:18 分类：问答Chrome not honouring ado.stream filename
The ASP code below grabs the content of a file (thisoutfile - which has a GUID as its file name) and streams it to the browser, providing the suggested filename to save as. This works in all browsers[详细]
2023-03-10 05:25 分类：问答How to obtain an ADORecordset from XML in VB6?
I have a requirement that my program should navigate between XML data source and SQL server. I have to read records from the XML file and have to return ADORecordset.[详细]
2023-03-09 14:03 分类：问答ASP / MS ACCESS check to see if username exists
I\'m creating my first project with ASP. This project is just making a basic login/logout with registration system. I was wondering how would I fix the below code so that when a user is registering to[详细]
2023-03-09 12:04 分类：问答ideas on how to take an email attachment (.csv), parse and insert into SQL DB automatically?
The case I have is the following and I\'m looking for any help someone can give as to how to approach it:[详细]
2023-03-08 09:01 分类：问答What is the equivalent datatype for datetime of SQL Server 2008 in ADO?
The datetime datatype in SQL Server 2008 supports milliseconds. I am trying to execute a stored procedure that accepts a datetime parameter, with an arg with milliseconds, as input/output value.[详细]
2023-03-08 03:45 分类：问答Upgrade websnap app to delphi 2005 - CoInitialize error
We have a current product written开发者_如何转开发 in Delphi 6 websnap, which I\'m attempting to upgrade to run under delphi 2005.[详细]
2023-03-08 02:05 分类：问答Close ado connection for access after finish update, and delete mdb file
I\'m trying to delete the mdb file after finished reading it. The process is: copyFile(originMdb, to targetMdb);[详细]
2023-03-07 22:09 分类：问答
加载中,请稍侯......