GRIDVIEW HOW TO RETRIVE THE SELCTED FIED .....HOW TO PASS

Question

IN GRIDVIEW HOW TO Retrieve the selected EMP ID using the DataKeyName value and HOW TO pass it to the query .......

JAYRAM · Answer

how to write the quarie in gridview

Rishikesh Kumar Singh · Answer

Step-1:- set the DataKeyNames property of your gridview to EMP_ID that is DataKeyNames=EMP_ID Step-2:- then on any event you can find that id with a single line of code string id = GridView1.DataKeys[e.RowIndex].Value.ToString(); Ex:- Suppose i am finding out it on RowUpdating event.... protected void GridView1_RowUpdating(object sender GridViewUpdateEventArgs e) { string id = GridView1.DataKeys[e.RowIndex].Value.ToString(); //this will give you the EMP_ID }

Pradip Pandey · Answer

Suppose you have Grid View Text=Select Row CommandName=Select CommandArgument=  /> In .cs file protected void GridView1_RowCommand(object sender GridViewCommandEventArgs e) { if (e.CommandName == Select) { string ID; string Name; int index = Convert.ToInt32(e.CommandArgument); ID = this.GridView1.DataKeys[index].Values[0].ToString(); Name = this.GridView1.DataKeys[index].Values[1].ToString(); ViewState[ID] = ID; } } And now you can pass the value of ViewState in your query string. Hope it will help.