how to save gridview data statically without worrying of values loss

Question

I was wondering if there is a way in which I can save gridview's data for example a row with columns:Id/name/date, as a static object/model, and when inserting new values, to access that saved data and compare values? like checking if name was changed and so on.. thanks!
my mission was originally to run different db queries so for that I had to check if NAME value for example was changed. I did it by comparing hiddenfield with currentvalue so it is working,
but I'd still rather find another "safer" way to do that (to access data before updating row. to access initial values )
any ideas and help will be appreciated!

Answer 1

Hi @gal mor ,
If you have two tables, you can try to create a dynamic DataTable using that, save to ViewState. Get the DataTable from ViewState whenever it is updated.

 dt = new DataTable();  
 ViewState["Test"] = dt;  
 GridView1.DataSource = (DataTable)ViewState["Test"];  
 GridView1.DataBind();  
////////////////////////GridView1_RowUpdating  
 DataTable dt = (DataTable)ViewState["Test"];  
 string a =  dt.Rows[e.RowIndex].ItemArray[1].ToString();  

Best regards,
Lan Huang

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.