|
 |
ado_dotnet thread: OLEDB and Data Adapters
Message #1 by david.horne@b... on Tue, 12 Feb 2002 07:10:47
|
|
Can anyone confirm that there is a problem with parameterised queries
using Data Adapters and OLEDB? (.NET Beta 2 using an Access database).
There seems to be no problem when using OleDbCommand objects with Data
Readers, but doesn't that cut out Datasets?
Message #2 by "Kyle" <Kyle@T...> on Tue, 12 Feb 2002 07:40:18 -0500
|
|
You can use a Data Reader to create a Dataset from an Access database.
You must programmatically create the dataset table schema and then when
you're reading in your data with the Data Reader you create a new
DataRow in the dataset table for each read record.
_____________________________________________
Kyle Dunn
Chief Information Officer
Funeral Services, Inc.
xxx-xxx-xxxx x 309
Kyle@F...
-----Original Message-----
From: david.horne@b... [mailto:david.horne@b...]
Sent: Tuesday, February 12, 2002 2:11 AM
To: ADO.NET
Subject: [ado_dotnet] OLEDB and Data Adapters
Can anyone confirm that there is a problem with parameterised queries
using Data Adapters and OLEDB? (.NET Beta 2 using an Access database).
There seems to be no problem when using OleDbCommand objects with Data
Readers, but doesn't that cut out Datasets?
$subst('Email.Unsub').
Message #3 by "David Horne" <david.horne@b...> on Tue, 12 Feb 2002 19:02:21 -0000
|
|
Thanks, Kyle - I'll give that a try.
T Y C Consultancy Limited
01722 714636
All mail attachments are virus checked
using regularly updated data files.
-----Original Message-----
From: Kyle [mailto:Kyle@T...]
Sent: 12 February 2002 12:40
To: ADO.NET
Subject: [ado_dotnet] RE: OLEDB and Data Adapters
You can use a Data Reader to create a Dataset from an Access database.
You must programmatically create the dataset table schema and then when
you're reading in your data with the Data Reader you create a new
DataRow in the dataset table for each read record.
_____________________________________________
Kyle Dunn
Chief Information Officer
Funeral Services, Inc.
xxx-xxx-xxxx x 309
Kyle@F...
-----Original Message-----
From: david.horne@b... [mailto:david.horne@b...]
Sent: Tuesday, February 12, 2002 2:11 AM
To: ADO.NET
Subject: [ado_dotnet] OLEDB and Data Adapters
Can anyone confirm that there is a problem with parameterised queries
using Data Adapters and OLEDB? (.NET Beta 2 using an Access database).
There seems to be no problem when using OleDbCommand objects with Data
Readers, but doesn't that cut out Datasets?
$subst('Email.Unsub').
$subst('Email.Unsub').
|
|
|
View Cart
