Top "Recordset" questions

Multiple Row Update SQL Trigger from Single Update SQL Statement

Ok. I am quite new to SQL triggers and have had some issues with them. Insert trigger works just fine, …

sql sql-server triggers recordset

Return recordset from function in classic ASP

I'm at a loss on how I can return a readable recordset from a function in classic ASP. This is …

function asp-classic adodb recordset

Whats the difference between rs.close vs rs = nothing in a RecordSet

I often find it confusing as to when it is appropriate to use: rs.Close opposed to Set rs = Nothing …

ms-access vba recordset

Select and updating data from datatable

I select data from my datatable, by using following code: DataRow[] result = table.Select("Size >= 230 AND Sex = 'm'"); Now …

c# select datatable recordset

Can you use a variable for the Field name when using AddNew to a record set?

I'm using a DAO recordset to update a table because of problems enocuntered here. This works fine when I know …

ms-access vba ms-access-2010 recordset

How to populate a ListBox with a ADODB.Recordset (Error 91) To Do Autocompletion in Access

I work on an Access DB and I have to use a Datasource connection to a SQL Server. To do …

ms-access autocomplete listbox recordset

Quickly select random ID from mysql table with millions of non-sequential records

I've looked around and there doesnt seem to be any easy way to do this. It almost looks like it's …

mysql random recordset

ADODB RecordSet as Access Report RecordSource

I have a simple form, a query and a report in Access 2003. I have to manipulate the results from the …

ms-access vba adodb recordset

ADODB open recordset fails / "Operation is not allowed when object is closed"

I have the following UDF in excel which uses ADO to connect to my MSSQL server. There it should execute …

sql-server vba ado adodb recordset

Is a Dataset the same as a Recordset

I used to work in VB.net and used Dataset's all the time when working with ADO, but now i'm …

c# vb.net ado.net dataset recordset