Embedded Gridiview within a Formview

rit01 · February 20th, 2006, 11:03 AM

Hi All

Here's an is it possible question...

I have a gridview control embedded within a formview. Is it possible to databind the Gridview att he same time as the Formview when selecting the update button on the Formvie.

Ta

Rit

jbenson001 · February 20th, 2006, 04:45 PM

Yes, as long as you set a sqldatasource for both objects.

rit01 · February 23rd, 2006, 10:03 AM

I can't get my head around how the formview update button would update a DB table using all the data from within all of the rows in a gridview... Usually a GridView updates one row at a time.

Rit

jbenson001 · February 23rd, 2006, 10:48 AM

You would have to get a reference to the gridview from within the formview. Then, loop through all the rows in the gridview, and generate an Insert/Update statment, or try using sqldatasource1.update().

rit01 · March 6th, 2006, 07:42 AM

Hi All

I have found an article regarding transforming a gridview so that it can process multiple updates but it is written in C#:

http://blogs.msdn.com/mattdotson/articles/490868.aspx

... is there a simple method of translating this into VB.Net?

Thanks,

Rit

jbenson001 · March 6th, 2006, 11:52 AM

use this site to convert the code:

http://www.developerfusion.co.uk/uti...sharptovb.aspx