How can solve this error?

Umm Hani

7y812Learn iOS Programming

how can pass value of gridview textbox to parameter?

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Umm Hani7y ago
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 = "";
}
0
Subbarao A7y ago
Hi,
in gridview, you need to find the value first then after you convert. Directly you can not assign the value.
0
Gajendra Jangid7y ago
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
0
Jaish Mathews7y ago
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() .
0
Umm Hani7y ago
@BikashSahu not work
0
Bikash Sahu7y ago
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())
-1

How can solve this error?

@BikashSahu not work