Batch Update in GridView control, is it possible?

[LearnMore.John]

Is it possible to update all the rows in a single postback using
Gridview Control,

regards
John

 

[Jared]

John

I am assuming you already have template columns set up to enter the
data into.

For this example I am using a TextBox inside a template column called
strDateOfClean.


int intCount = GridMain.Rows.Count;

int intIndex = 0;

while (intIndex < intCount)
{

TextBox strDateOfClean =
GridMain.Rows[intIndex].FindControl("strDateOfClean") as TextBox;


//Then you can do what you need to here to save the
//strDateOfClean, such as updating an SQL table. e.g. Adding it to an
SQL string
//and firing a command.
//string strsql = "Update tblTest set strTest = '" +
strDateOfClean.Text + "'";



intIndex += 1;

}


Cheers

Jared

 

[Jared]

Missed a couple of bits you might need...

This code can be fired from a button or a row command, either will
work.

In the SQL string I missed out that you need to refernce a primary key,
which needs to be stored in your GridView somewhere, e.g.

string strsql = "Update tblTest set strTest = '" + strDateOfClean.Text
+ "' where ID = " + GridMain.Rows[intIndex].Cells[0].Text;

Hope this is useful

Jared

John

I am assuming you already have template columns set up to enter the
data into.

For this example I am using a TextBox inside a template column called
strDateOfClean.



int intCount = GridMain.Rows.Count;

int intIndex = 0;

while (intIndex < intCount)
{

TextBox strDateOfClean =
GridMain.Rows[intIndex].FindControl("strDateOfClean") as TextBox;


//Then you can do what you need to here to save the
//strDateOfClean, such as updating an SQL table. e.g. Adding it to an
SQL string
//and firing a command.
//string strsql = "Update tblTest set strTest = '" +
strDateOfClean.Text + "'";



intIndex += 1;

}


Cheers

Jared

Is it possible to update all the rows in a single postback using
Gridview Control,

regards
John