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 Viswanath · 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 Viswanath · 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 Viswanath · 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" />

GridView RowCommand in Asp.net

Answers (7)