Cast a DatagridView row to a DataRow

[Jeff Steinkamp (N7YG)]

I have a DatagridView that is populated from a SQL statement.  The user has the option of filtering that DataGridView even further.  What I need to be able to do is either cast the filtered results back to a DataTable, or iterate over the filtered results and cast each row back to a DataRow so I can feed that to a specialized  export routine.

 

Any idea how to accomplish this?

 

Jeff K. Steinkamp N7YG
Tucson, AZ
SCUD Missile Coordinates:
N032-13-55.02  W110-55-52.79
Registered Linux User: 420428
------------------------------------------------------

 

EMPLOYERS do it to employees

[Stephen Russell]

On Mon, Oct 11, 2010 at 10:51 AM, Jeff Steinkamp (N7YG) <n7...@n7yg.com> wrote:
> I have a DatagridView that is populated from a SQL statement.  The user has
> the option of filtering that DataGridView even further.  What I need to be
> able to do is either cast the filtered results back to a DataTable, or
> iterate over the filtered results and cast each row back to a DataRow so I
> can feed that to a specialized  export routine.
>
> Any idea how to accomplish this?

-----------------------

You were so close.

DataView :

<http://davidhayden.com/blog/dave/archive/2006/02/11/2798.aspx>

DataView to DataTable:
<http://www.daniweb.com/code/snippet217027.html>

--
Stephen Russell

Sr. Production Systems Programmer
CIMSgts

901.246-0159 cell

[Jeff Steinkamp (N7YG)]

?Actually, this was a lot easier to do than I thought. I have a Datasource
(ds) that is tied to a BindingSource and the DataGrivdView so I just did the
following

For Each row As DataRow In ds.Tables(0).Select(userFilter)

'do the specialized processing on the row
Next

Now that I have proved this works, I can eliminate about 50 lines of code
with another routine where I am processing each cell in the grid by pulling
a compete row and do the processing in a couple lines of code.

Jeff K. Steinkamp N7YG
Tucson, AZ
SCUD Missile Coordinates:
N032-13-55.02 W110-55-52.79
Registered Linux User: 420428
------------------------------------------------------

Whoever profits by the crime is guilty of it.

--------------------------------------------------
From: "Stephen Russell" <sruss...@gmail.com>
Sent: Tuesday, October 12, 2010 5:31 AM
To: <dotnetde...@googlegroups.com>
Subject: Re: [DotNetDevelopment] Cast a DatagridView row to a DataRow

[Stephen Russell]

On Tue, Oct 12, 2010 at 6:12 PM, Jeff Steinkamp (N7YG)
<jkste...@gmail.com> wrote:
> ?Actually, this was a lot easier to do than I thought.  I have a Datasource
> (ds) that is tied to a BindingSource and the DataGrivdView so I just did the
> following
>
>        For Each row As DataRow In ds.Tables(0).Select(userFilter)
>
>                'do the specialized processing on the row
>               Next
>
> Now that I have proved this works, I can eliminate about 50 lines of code
> with another routine where I am processing each cell in the grid by pulling
> a compete row and do the processing in a couple lines of code.

-----------------

Sounds good. Your changes are done to the ds.dt so they are ready to
be updated if need be as well.

[Arsalan Tamiz]

BTW,

DataGridView's Row has a property DataBoundItem this property returns the DataRowView in case you have bind the DataGridView with a BindingSource. Therefore casting can be done,

Dim drv as DataRowView

Dim objDataRow as DataRow

drv = Me.DataGridView1.Rows(0).DataBoundItem, DataRowView

objDataRow = drv.Row