Click here to Skip to main content
15,867,686 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi.
I have a gridView and i have written it's Edit & Update statement with my own ,but the problem i have i can't convert two of gridview textbox which are assigned to BirthDate(datatype=date)and average(datatype=decimal) , and now when i debugg the solution this message is appeared:

The string was not recognized as a valid DateTime. There is an unknown word starting at index 0.
and somethig the same message for average.

my code i have written is as below:
C#
protected void Grid_Updating(object sender, GridViewUpdateEventArgs e) 
    { 
        SqlCommand cmd = DataProvider.GenerateCommand("Update_HowzeEducation_SP", CommandType.StoredProcedure); 
        cmd.Connection.Open(); 
 
        cmd.Parameters.Add("@FieldName", SqlDbType.NVarChar).Value = ((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text; 
        cmd.Parameters.Add("@FinishLevelDate", SqlDbType.Date).Value = Convert.ToDateTime(((TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text.Trim()); 
        cmd.Parameters.Add("@Average", SqlDbType.Decimal).Value = decimal.parse(((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text); 
        cmd.Parameters.Add("@SchoolName", SqlDbType.NVarChar).Value = ((TextBox)GridView1.Rows[e.RowIndex].Cells[4].Controls[0]).Text; 
        cmd.Parameters.Add("@StudyCityDescribtion", SqlDbType.NVarChar).Value = ((TextBox)GridView1.Rows[e.RowIndex].Cells[5].Controls[0]).Text; 
        cmd.Parameters.Add("@ThesisTitle", SqlDbType.NVarChar).Value = ((TextBox)GridView1.Rows[e.RowIndex].Cells[6].Controls[0]).Text; 
        cmd.Parameters.Add("@Describtion", SqlDbType.NVarChar).Value = ((TextBox)GridView1.Rows[e.RowIndex].Cells[7].Controls[0]).Text; 
        cmd.Parameters.Add("@HowzeEducationId", SqlDbType.Int).Value = GlobalVariables.HowzeEducationId; 
 
        cmd.ExecuteScalar(); 
 
    } 
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900