how to save data from gridview on a footer button click

Question

THIS IS MY GRIDVIEW

Slno	date	type	ACTION
1	2019 /01/10	1	(button) EDIT
2	2019/01/10	2	(button) EDI

(button)SAVE

i'm already datakeysname is set in the gridview.and

i want save data from gridview using footer buttonand that datakeyname value paasing to sql..

on that btnclick event is generated.

i didn't get each row datakeynames value.

string id=gdvlist.Datakeys[gr.rowindex].value.tostring(); i pass this line but i got this type of error

Index was out of range. Must be non-negative and less than the size of the collection.

how to access datakeyname and how to save data fron grid on footer button click.

plz help me. thnkx in adv

Bryian Tan · Answer

This post might help https://stackoverflow.com/questions/2818203/get-datakey-values-in-gridview-rowcommand

Satyaprakash Samantaray · Answer

Check this real time article. https://www.c-sharpcorner.com/article/crud-using-stored-procedure-in-asp-net-gridview-real-time/

Satyaprakash Samantaray · Answer

This can solve your problem. https://www.c-sharpcorner.com/UploadFile/009464/make-edit-update-and-delete-operation-in-gridview-in-Asp-Net/

Reylin Mathew · Answer

i wrote this code..but get only one row .if dtdata get multiple rows but i got onl 1 row and i didn't get second row. foreach (GridViewRow row in gvdData.Rows) { DataTable dtdata= mg.GetDataLeave(id); for (int i=0;i { int Lid = Convert.ToInt32(dtdata.Rows[0]["ID"].ToString()); Session["Id"] = Lid; int dataiD = Convert.ToInt32(dtdataRows[0]["data_ID"].ToString()); Session["dataiD "] = dataiD ; DropDownList ddlType = gvdData.Rows[row.RowIndex].FindControl("ddlType") as DropDownList; TextBox txtReason = gvdData.Rows[row.RowIndex].FindControl("txtReason") as TextBox; mg.AddEntry(Session["Id"].ToString(), ddlType.SelectedValue, txtReason.Text, id); txtReason.Text = ""; divSucc.Visible = true; lblSucc.Visible = true; lblSucc.Text = "Save Data Successfully!"; } plz help mee

Sanwar Ranwa · Answer

Hello Please check these Links https://www.c-sharpcorner.com/UploadFile/33b051/saving-data-from-gridview-footer-in-asp/ https://www.aspsnippets.com/Articles/Add-record-to-Database-using-ASP.Net-GridView-EmptyDataTemplate-and-FooterTemplate.aspx