how to save data from gridview on a footer button click

Reylin Mathew

7y1.7k.NET

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bryian Tan7y ago
Accepted answer
This post might help https://stackoverflow.com/questions/2818203/get-datakey-values-in-gridview-rowcommand
0
Reylin Mathew7y ago
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
0
Satyaprakash Samantaray7y ago
Check this real time article.

https://www.c-sharpcorner.com/article/crud-using-stored-procedure-in-asp-net-gridview-real-time/
0
Satyaprakash Samantaray7y ago
This can solve your problem.

https://www.c-sharpcorner.com/UploadFile/009464/make-edit-update-and-delete-operation-in-gridview-in-Asp-Net/
0
Sanwar Ranwa7y ago
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
0