Accessing data in code

28 Aug 2006 2:46 AM

John

Hi

I have opened a data connection to an access db in my vb.net windows form
app. I need to do the following but am not sure how to do it in code;

1. Open one of the tables
2. Read value from a record.
3. Insert the record into a second table in the same db.
4. Delete record from first table.
5. Go to step 1 is any records are left in first table.

Would appreciate if someone can give any pointers on how to achieve the
above in code.

Thanks

Regards

28 Aug 2006 3:12 AM

GhostInAK

Hello John,

RTFM. Google is your friend. MSDN smells funny, but is a generaous ally.

-Boo

Show quoteHide quote

> Hi
>
> I have opened a data connection to an access db in my vb.net windows
> form app. I need to do the following but am not sure how to do it in
> code;
>
> 1. Open one of the tables
> 2. Read value from a record.
> 3. Insert the record into a second table in the same db.
> 4. Delete record from first table.
> 5. Go to step 1 is any records are left in first table.
> Would appreciate if someone can give any pointers on how to achieve
> the above in code.
>
> Thanks
>
> Regards
>

28 Aug 2006 3:57 AM

John

There are several ways data sets, data readers and for someone new it is
mind boggling as to which method is preferable for a specific app.

Regards

Show quoteHide quote

"GhostInAK" <ghosti***@gmail.com> wrote in message
news:c71747b42ddce8c89823dcaa0c26@news.microsoft.com...
> Hello John,
>
> RTFM. Google is your friend. MSDN smells funny, but is a generaous ally.
>
> -Boo
>
>> Hi
>>
>> I have opened a data connection to an access db in my vb.net windows
>> form app. I need to do the following but am not sure how to do it in
>> code;
>>
>> 1. Open one of the tables
>> 2. Read value from a record.
>> 3. Insert the record into a second table in the same db.
>> 4. Delete record from first table.
>> 5. Go to step 1 is any records are left in first table.
>> Would appreciate if someone can give any pointers on how to achieve
>> the above in code.
>>
>> Thanks
>>
>> Regards
>>
>
>