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
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
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
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
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.
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
The case I have is the following and I\'m looking for any help someone can give as to how to approach it:
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.
We have a current product written开发者_如何转开发 in Delphi 6 websnap, which I\'m attempting to upgrade to run under delphi 2005.
I\'m trying to delete the mdb file after finished reading it. The process is: copyFile(originMdb, to targetMdb);