Submit GridView to database at a time

Posted by Suneel161 under Regular Expressions on 3/24/2010 | Views : 6519 | Status : [Member] | Replies : 3

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi all,
how to submit 10 records of the GridView to Database at a time.and after that gridview will be empty...

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Raja on: 3/24/2010 [Member] Starter

0	I hope below description will give you an idea. Loop through all the rows of the GridView using below code snippet and get the columns data and save into the database. foreach (GridViewRow row in GridView1.Rows) { // use row.DataColumns to retrive the column data // get all columns data and save into the database } Then set GridView1.DataSource = null that will empty the GridView. Regards, Raja, USA Suneel161, if this helps please login to Mark As Answer. \| Alert Moderator

I hope below description will give you an idea.

Loop through all the rows of the GridView using below code snippet and get the columns data and save into the database.

foreach (GridViewRow row in GridView1.Rows)

{

    // use row.DataColumns to retrive the column data

   // get all columns data and save into the database

}

Then set GridView1.DataSource = null that will empty the GridView.

Regards,
Raja, USA

Suneel161, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sagarp on: 3/24/2010 [Member] Bronze

0	check following links http://forums.asp.net/t/1152078.aspx Thanks SagarP http://www.emanonsolutions.net http://emanonsolutions.blogspot.com/ Suneel161, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Lakhangarg on: 3/25/2010 [Member] [Moderator] Silver

0	Hi- You can use the bulk insert for that. Thanks Lakhan Pal Garg Suneel161, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts