Suppose you display a data having 200 records in a
datagrid. Then you edit 100 records of them. Now when you
will press update button,all 100 records should be updated
in single shot rather than reading every record and
updating. How to do it?
Answers were Sorted based on User's Feedback
Answer / guest
Here, bind primary key of database to datagrid column make
it visible false.
and travel loop as
foreach(DataGridItem dataItem in DataGrid1.Items)
{
priceText = (TextBox)dataItem.FindControl
("txtBookPrice");
bookIdText = (TextBox)dataItem.FindControl("txtBookId");
Updatecode_for_perticular_row ();
}
txtBookPrice= textbox from witch u would like to update
txtBookId= test i.e. unique id comming from database
With help of unique id in for loop find perticular text in
texbox and update.
This code you will write on update button click.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / arief
First you load 20 records to DataGrid and add one
more templet field like"Chech Box" finally add one button
in your page for update operation
you write code whatever CheckBox clike get all row
id's and you can update row based on selected id's
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / pradeep
Each row is having Edit/Update/Cancel button.
In "_UpdateCommand" event, we can write a code to update
directly into the database. But it is not good practice.
For updating whole records in a single event, we need to
have hidden column for updateflag and while updating we can
store the updated data into session. By using BUTTON
control out side of datagrid, we can find only 100 records
(updated records) based on updateflag and we can update
only those records into DB.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / masuduz zaman
By using dataSet.GetChanges(DataRowState.Modified) method we can update all 100 records at a time.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between a Debug and Release build? Is there a significant speed difference? Why or why not?
Describe paging in asp.net?
Why would anyone need to implement their own hashtable or linked list?
What is asp.net localization?
Can you explain the importance of finalize method in .net?
What are early binding and late binding.
What is the use of data set in asp.net?
How does session id work?
What is the default timeout for a cookie?
What do you mean by authentication and authorization
In which interface the template of any control like Gridview would Initiate?
How can we call webservices in Banking Applications? and where we are using it?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)