GridView RowCommand in Asp.net

Question

Sir I am getting an error in the gridView RowCommand event in asp.net. My task is to display the selected value in textboxes belong to view1. This is the error:- please help me in this error.

Bineesh VP · Answer

Sir I just changed the itemTemplte to LinkButton;- Here the code:- ' CommandName=Select>Select And the output of this is:- Thank you for the helping mentality.

Bineesh VP · Answer

Here the .aspx code:- BackColor=#DEBA84 BorderColor=#DEBA84 BorderStyle=None BorderWidth=1px CellPadding=3 CellSpacing=2 DataKeyNames=examId onrowcancelingedit=dgvExam_RowCancelingEdit onrowcommand=dgvExam_RowCommand onrowdeleting=dgvExam_RowDeleting onrowediting=dgvExam_RowEditing onrowupdating=dgvExam_RowUpdating onselectedindexchanged=dgvExam_SelectedIndexChanged> '> '> SelectImageUrl=~/Photos/Select.gif ShowSelectButton=true /> HeaderText=Edit ShowEditButton=true /> HeaderText=Delete ShowDeleteButton=true />

Sanjeeb Lenka · Answer

hi As your dataset is null thats why you are getting exception. plz share your gridview aspx code.

Bineesh VP · Answer

Code to create commandField:- asp:CommandField ButtonType=Image HeaderText=Select SelectImageUrl=~/Photos/Select.gif ShowSelectButton=true /> .cs code protected void dgvExam_RowCommand(object sender GridViewCommandEventArgs e) { if (e.CommandName == Select) { mvExam.ActiveViewIndex = 0; int inId = Convert.ToInt32(e.CommandArgument); if (sqlCon.State == ConnectionState.Closed) { sqlCon.Open(); } SqlDataAdapter sqlDa = new SqlDataAdapter(select * from tbl_Exam where examId=' + inId + ' sqlCon); DataSet DS = new DataSet(); sqlDa.Fill(DS); txtExamName.Text = DS.Tables[0].Rows[0][examName].ToString(); ddlclassName.SelectedValue = DS.Tables[0].Rows[0][classId].ToString(); } } I put break point and comes to knw that inId is Zero and Dataset==NULL.

Sivaraman Dhamodaran · Answer

I hope your SQL Select statement does not return any rows. Check your query in SQL Server itself.

Sanjeeb Lenka · Answer

hi put a break point and check data is coming to dataset ds or not.

Sanjeeb Lenka · Answer

change your button code in aspx: CommandName=Select CommandArgument=' examId ) %>' SelectImageUrl=~/Photos/Select.gif ShowSelectButton=true />