Re: When(why) use DataSet?
- From: "Brendan Reynolds" <brenreyn@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 23 Jun 2005 10:15:56 +0100
Have you seen the KB article 'HOW TO: Retrieve the Identity Value While
Inserting Records into Access Database By Using Visual Basic .NET' at the
following URL ...
http://support.microsoft.com/default.aspx?scid=kb;en-us;815629
While this article does use a dataset and the RowUpdated event, this is just
for illustration - the technique used is not dependent on using a dataset.
There's another KB article ('INFO: Jet OLE DB Provider Version 4.0 Supports
SELECT @@Identity') that demonstrates how to use the same technique in
'classic' VB, where of course the dataset did not exist. The code in that
article may actually be easier to adapt to your needs than the VB.NET
example. Here's the URL for that second article ...
http://support.microsoft.com/kb/232144/EN-US/
--
Brendan Reynolds (MVP)
"sparks" <sparks@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:89641C46-A07A-4EC6-B901-6D677EC7A690@xxxxxxxxxxxxxxxx
>I have a very simple Access database which consists of only one table and
>an
> auto number field (ID) has been used as the primary key for the records.
> All
> the columns are directly mapped to a object's properties except the ID
> property of the object is set to 0 initially.
>
> I only use OleDbCommand object to execute sql statement but is there any
> way
> to get the value of the ID column of a just inserted row (I want to update
> the ID property of the object after it's been added to the database)? I
> know
> there's a RowUpdated event that I can use to get the data when DataAdapter
> and DataSet are used but they are seems to me overkills the performence of
> the application since I need to fill all records of the db into the
> dataSet.
> So this is my newbie question about ADO .NET DataSet class: Why do we
> really
> need this class to storing data into memory especially when there is a lot
> of
> "data" in the database? And also how could I solve my problem of getting
> the
> value of the ID column (Is only using a autonumber field as the primary
> key a
> bad choice of database design?). Thanks in Advance!
>
> regards,
>
> Zhenyu Lu
>
.
- References:
- When(why) use DataSet?
- From: sparks
- When(why) use DataSet?
- Prev by Date: ADO, VB6, String data, right truncation
- Next by Date: Call oracle stored procedure that have a NUMBER argument
- Previous by thread: Re: When(why) use DataSet?
- Next by thread: ADO, VB6, String data, right truncation
- Index(es):
Relevant Pages
|
|
