How can solve this error?

Question

how can pass value of gridview textbox to parameter?

Umm Hani · Answer

Accept answers using (SqlConnection sqlCon = new SqlConnection(strConnectionString)) { sqlCon.Open(); string query = "INSERT INTO EmpCompany(EmpId,CompanyName,PositionID,ExpYear) VALUES(@EmpId,@CompanyName,@PositionID,@ExpYear)"; SqlCommand sqlCmd = new SqlCommand(query, sqlCon); ; //sqlCmd.Parameters.AddWithValue("@EmpCmpID", (gvCompany.FooterRow.FindControl("txtCompanyIDFooter") as TextBox).Text.Trim()); sqlCmd.Parameters.AddWithValue("@EmpId", _EmpID); sqlCmd.Parameters.AddWithValue("@CompanyName", (gvCompany.FooterRow.FindControl("txtCompanyNameFooter") as TextBox).Text.Trim()); sqlCmd.Parameters.AddWithValue("@PositionID", (gvCompany.FooterRow.FindControl("txtPositionFooter") as TextBox).Text.Trim()); sqlCmd.Parameters.AddWithValue("@ExpYear", (gvCompany.FooterRow.FindControl("txtExpYearFooter") as TextBox).Text.Trim()); sqlCmd.ExecuteNonQuery(); LoadProducts(); lblSuccessMessage.Text = "New Record Added"; lblErrorMessage.Text = ""; }

Subbarao A · Answer

Hi, in gridview, you need to find the value first then after you convert. Directly you can not assign the value.

Gajendra Jangid · Answer

hello Umm hani, for insert value you have to get textbox using following code: TextBox tb = (TextBox)row.FindControl("txtReturned"); and then put textbox value ....tb.text

Jaish Mathews · Answer

Please put a screenshot in debug mode showing the value of "dgvRow.cells[0].Text" . I assume it has a value which won't work with Convert.ToInt32() .

Umm Hani · Answer

@BikashSahu not work

Bikash Sahu · Answer

https://stackoverflow.com/questions/38644659/why-am-i-receiving-input-string-not-in-correct-format-while-retreiving-gridvie try this Convert.ToInt32(dgvRow.cells[0].Text.ToString())

How can solve this error?

Answers (6)