I must be doing something seriously weird as I can't find anything on
what I need to do. I have a form that imports an Excel file into a dgv
(to preview the data) I then want to export this into an existing
table in a sql server database.

I can't find anything to do this direct from the dgv. Does anyone have
any code or methods for doing this? Or am I going about this in
completely the wrong way?

Any help greatly appreciated

Re: Export from Datagridview by RobinS

RobinS
Wed Apr 25 15:17:12 CDT 2007

Import it into a dataset, then bind it to your grid. I assume all of the
records are going to be inserted into SQLServer? You'll have to add an
Insert Object to your Command Object and call Update on your data adapter,
and it should work.

Robin S.
-----------------------
"thewiz" <immediateintelligence@googlemail.com> wrote in message
news:1177500159.440667.322520@r35g2000prh.googlegroups.com...
>I must be doing something seriously weird as I can't find anything on
> what I need to do. I have a form that imports an Excel file into a dgv
> (to preview the data) I then want to export this into an existing
> table in a sql server database.
>
> I can't find anything to do this direct from the dgv. Does anyone have
> any code or methods for doing this? Or am I going about this in
> completely the wrong way?
>
> Any help greatly appreciated
>