Update and Delete in Session Datatable in C#

Question

Hi i have a Gridview data's which is bind from session Datatable. now i need Edit and delete the record using gridview link button. After editing and deleting the Record how update the session datatable and bind to the grid?

Sunny Sharma · Answer

Hi Kumar I do support the answer by Jignesh Trivedi  you must have Id field in your datatable to identify the data table record otherwise you will be messing up the data with inconsistency.

Jignesh Trivedi · Answer

hii think you must have Id field in your datatable to identify the data table record. In your update event identify the record from dataset and update your dataset and rebind your grid. In onrowupdating event DataTable dt = Session[dt] as DataTable; if(dt != null) { //find out key value var key = txtid.Text // replace correct code var drow = dt.Select(key= key ); drow[0] = txtCode.Text ; // update your value drow[1] = txtName.Text ; // update your value // put your dataset again in session Session[dt] = dt; } hope this will help you.

Kumar S · Answer

Hi This is my code. Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 DataTable dt = new DataTable (); if (Session[ dt ] != null ) dt = ( DataTable )Session[ dt ]; else { dt.Columns.Add( Code ); dt.Columns.Add( Name ); Session[ dt ] = dt; } dr[ Code ] = txtDiagCode.Text.Trim(); dr[ Name ] = txtDiagName.Text.Trim(); dt.Rows.Add(dr); Session[ dt ] = dt; gvDiagnosis.DataSource = dt; gvDiagnosis.DataBind(); LinkButton edit = ( LinkButton )sender; GridViewRow gvrow = ( GridViewRow )edit.NamingContainer; txtCode.Text = gvrow.Cells[0].Text.ToString(); txtName.Text = gvrow.Cells[1].Text.ToString(); After this how can i update the records and bind to grid. /* Style Definitions */ table.MsoNormalTable{mso-style-name:Table Normal;mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin-top:0in;mso-para-margin-right:0in;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0in;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:Calibrisans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:Times New Roman;mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;}

Iftikar Hussain · Answer

Hi Please refer the below link http://www.dotnetspider.com/resources/20462-Bind-Gridview-from-Session-Then-Edit-Update.aspx Regards Iftikar

Sunny Sharma · Answer

Hi Kumar please show us your code that you've tried so far so that we could help you a little faster.