protected void DetailsViewDetail_ItemUpdating(object sender, DetailsViewUpdateEventArgs e) { TextBox newRecipeName = (TextBox)DetailsViewDetail.FindControl("editRecipename"); TextBox newDesc = (TextBox)DetailsViewDetail.FindControl("editDesc"); TextBox newNum = (TextBox)DetailsViewDetail.FindControl("editNum"); TextBox neweditMinute = (TextBox)DetailsViewDetail.FindControl("editMinute"); DropDownList newSeleCat = (DropDownList)DetailsViewDetail.FindControl("categoryList"); string newReName = newRecipeName.Text; string newDes = newDesc.Text; int servingNum = int.Parse(newNum.Text); int minute = int.Parse(neweditMinute.Text); string categ = newSeleCat.SelectedValue; string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString2"].ConnectionString; OracleConnection conn = new OracleConnection(); conn.ConnectionString = connectionString; OracleCommand comm = conn.CreateCommand(); try { comm.Connection.Open(); comm.CommandType = CommandType.Text; comm.CommandText = "update recipes set recipename='" + newReName + "' , description='" + newDes + "', servingnum=" + servingNum + ", cookingminutes=" + minute + ", categoryid='" + categ + "' where recipeid = " + Request.QueryString["key"]; comm.ExecuteNonQuery(); } catch (SqlException ex) { exception.Text = ex.Message; } finally { comm.Connection.Close(); } DetailsViewDetail.ChangeMode(DetailsViewMode.ReadOnly); BindList(); }
protected void DetailsViewDetail_ModeChanging(object sender, DetailsViewModeEventArgs e) { DetailsViewDetail.ChangeMode(e.NewMode); BindList(); }