display record from gridview to textbox

Question

i am using gridview cotrol in that i am displaying field such as EmployeeId,Name,Age,Sex etc Name is a Template Column field. and name is shown as a LinkButton . when i click any name then that record should display in a text box. how to do that #form1 { height: 206px; } .style1 { height: 42px; } .style2 { width: 65px; height: 42px; } .style3 { width: 65px; } .style4 { width: 19px; } .style5 { height: 22px; }

jignesh kadvani · Answer

below is my GridView Code. ' CommandName="Edit" CommandArgument=' '> in another panel control i have a follwing Control. txtEname, txtAge, RadioButtonSex, DropDownQualification, txtPercentage, DropDownPassingYear. When user click any Name of Employee Name Column in GridView then That Record Should fill in Relevent text box. i tried below code to get data in Text Box when user click Employee Name field of Grid View . protected void gvEmployee_RowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName == "Edit") { int id = Convert.ToInt32(e.CommandArgument); GridViewRow selectedRow = gvEmployee.Rows[id]; txtName.Text = selectedRow.Cells[2].Text; txtAge.Text = selectedRow.Cells[3].Text; ddlQualification.Text = selectedRow.Cells[5].Text; txtPercentage.Text = selectedRow.Cells[6].Text; ddlPassingYear.Text = selectedRow.Cells[7].Text; } } catch (Exception Ex) { throw Ex; } } code comes upto txtName.text and then went to catch statement. so plz give me solution. if possible give code. i hope u gatting my problem.

Honey · Answer

Hi Jignesh kadvani, --> First set the DataKeyName as Primarykey to that table, for example if EmployeeId is the primary key to the table, then set the Gridview Datakey Name as EmployeeId. --> Get the data from database. If you are retrieved that into a data reader we can use this code as dr.Read(); TxtExample.Text="Employee Id="+dr["EmployeeId"].ToString(); TxtExample .Text = Environment.NewLine; TxtExample.Text+="Employee Name= "+dr["EmployeeName"].ToString(); TxtExample .Text = Environment.NewLine; TxtExample.Text+="Age= "+dr["Age"].ToString(); TxtExample .Text = Environment.NewLine; TxtExample.Text+="Sex= "+dr["Sex"].ToString(); dr.Close();