Saving the Values entering dynamically created Textbox into database
-
How do I save the values entering into textbox that is dynamically created to database My Code for (int i = 0; i < Grid.Rows.Count; i++) //Grid.Rows.Count { //TextBox CC = (TextBox)Grid.Rows[i].Cells[2].FindControl("txtCA"); //TextBox CC1 = (TextBox)Grid.Rows[i].Cells[2].FindControl("txtCA") as TextBox; string StdMat = Grid.Rows[i].Cells[0].Text; string CA = ((TextBox)Grid.Rows[i].Cells[2].FindControl("txtCA")).Text; string UserID = Grid.Rows[i].Cells[1].Text; Response.Write("CA= " + CC1 + "
"); MySqlCommand cmdd = new MySqlCommand("UPDATE resultstable2 SET CA=@ca WHERE student_ID=@student_ID", conn);// coursecode=@coursecode cmdd.Parameters.AddWithValue("@ca", CA); cmdd.Parameters.AddWithValue("@coursecode", cboCourseCode.Text); cmdd.Parameters.AddWithValue("@student_ID", StdMat); cmdd.ExecuteNonQuery(); } -
How do I save the values entering into textbox that is dynamically created to database My Code for (int i = 0; i < Grid.Rows.Count; i++) //Grid.Rows.Count { //TextBox CC = (TextBox)Grid.Rows[i].Cells[2].FindControl("txtCA"); //TextBox CC1 = (TextBox)Grid.Rows[i].Cells[2].FindControl("txtCA") as TextBox; string StdMat = Grid.Rows[i].Cells[0].Text; string CA = ((TextBox)Grid.Rows[i].Cells[2].FindControl("txtCA")).Text; string UserID = Grid.Rows[i].Cells[1].Text; Response.Write("CA= " + CC1 + "
"); MySqlCommand cmdd = new MySqlCommand("UPDATE resultstable2 SET CA=@ca WHERE student_ID=@student_ID", conn);// coursecode=@coursecode cmdd.Parameters.AddWithValue("@ca", CA); cmdd.Parameters.AddWithValue("@coursecode", cboCourseCode.Text); cmdd.Parameters.AddWithValue("@student_ID", StdMat); cmdd.ExecuteNonQuery(); }Where do you stuck. Error comes in which line number. or What is the error
hi