DataGridView

Hi All, I have been searching everywhere but I am totally stumped. Can
anyone PLEASE help.

I am using VB.Net 2005 edition and have a DataGridView (DGV)on my form.

The DGV is NOT bound to anything as I want the user to input their values.
Once they have finished I THEN want to save the values in the DGV to a MS
Access table.

How do I do this?

My DataGridView is called DGV1 and my table is db1.mdb.

I would KILL for any example code you may be able to pass my way.

THANK YOU

Rick
Thu Apr 24 07:25:42 CDT 2008

Completely untested, but can't you do something like:

for each dgvr as datagridviewrow in dgv.rows
table.row.Column = dgvr("<Col name> or <Col index>")
next

Rick


"Bails" <affinity_sales@australiaonline.net.au> wrote in message
news:1209034999.930379@kangaroo.ozonline.com.au...
> Hi All, I have been searching everywhere but I am totally stumped. Can
> anyone PLEASE help.
>
> I am using VB.Net 2005 edition and have a DataGridView (DGV)on my form.
>
> The DGV is NOT bound to anything as I want the user to input their values.
> Once they have finished I THEN want to save the values in the DGV to a MS
> Access table.
>
> How do I do this?
>
> My DataGridView is called DGV1 and my table is db1.mdb.
>
> I would KILL for any example code you may be able to pass my way.
>
> THANK YOU
>
>

RobinS
Sat Apr 26 22:32:08 CDT 2008

I think you can also access the cells using dgv.Cells[intRow, intCol], so
you could loop through the data that way as well.

RobinS.
--------------------

"Rick" <RickREMOVETHIS@LakeValleySeed.com> wrote in message
news:ulIAeZgpIHA.1236@TK2MSFTNGP02.phx.gbl...
> Completely untested, but can't you do something like:
>
> for each dgvr as datagridviewrow in dgv.rows
> table.row.Column = dgvr("<Col name> or <Col index>")
> next
>
> Rick
>
>
> "Bails" <affinity_sales@australiaonline.net.au> wrote in message
> news:1209034999.930379@kangaroo.ozonline.com.au...
>> Hi All, I have been searching everywhere but I am totally stumped. Can
>> anyone PLEASE help.
>>
>> I am using VB.Net 2005 edition and have a DataGridView (DGV)on my form.
>>
>> The DGV is NOT bound to anything as I want the user to input their
>> values. Once they have finished I THEN want to save the values in the DGV
>> to a MS Access table.
>>
>> How do I do this?
>>
>> My DataGridView is called DGV1 and my table is db1.mdb.
>>
>> I would KILL for any example code you may be able to pass my way.
>>
>> THANK YOU
>>
>>
>
>