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();
}