protected void btnDelete_Click(object sender, EventArgs e)
{
string connectionString =
ConfigurationManager.ConnectionStrings["ConnectionString2"].ConnectionString;
OracleConnection conn = new OracleConnection();
conn.ConnectionString = connectionString;
OracleCommand comm = conn.CreateCommand();
comm.CommandText = "delete from recipes where recipeid=" + Request.QueryString["key"];
comm.CommandType = CommandType.Text;
DataTable table;
table = new DataTable();
try
{
comm.Connection.Open();
OracleDataReader reader = comm.ExecuteReader();
table.Load(reader);
}
catch (SqlException ex)
{
exception.Text = ex.Message;
}
catch (Exception ex)
{
exception.Text = ex.Message;
}
finally
{
comm.Connection.Close();
}
DetailsViewDetail.DataSource = table;
DetailsViewDetail.DataBind();
}
private void BindList()
{
string connectionString =
ConfigurationManager.ConnectionStrings["ConnectionString2"].ConnectionString;
OracleConnection conn = new OracleConnection();
conn.ConnectionString = connectionString;
OracleCommand comm = conn.CreateCommand();
OracleDataReader reader;
DataTable recipeDetailTable = new DataTable();
DataTable categoryTable = new DataTable();
DataTable ingredientsTable = new DataTable();
DataTable listTable = new DataTable();
try
{
// load recipe data
comm.CommandText = "select u.name as Submity_by, c.type as category, r.recipeid, r.categoryid, r.recipename,r.userID, r.description, r.servingnum, r.cookingminutes from recipes r right outer join users u on r.userid = u.userid join categories c on c.categoryid = r.categoryid join recipesLinkIngredients on r.recipeid = recipesLinkIngredients.recipeid right outer join ingredients i on recipesLinkIngredients.ingredientID = i.ingredientID where r.recipeid=" + Request.QueryString["key"];
comm.CommandType = CommandType.Text;
comm.Connection.Open();
reader = comm.ExecuteReader();
recipeDetailTable.Load(reader);
// bind recipe detail view
DetailsViewDetail.DataSource = recipeDetailTable;
DetailsViewDetail.DataBind();
// load selected category data
comm.Parameters.Clear();
comm.CommandText = "select r.categoryid, c.type from recipes r left join categories c on c.categoryid = r.categoryid right outer join recipesLinkIngredients on r.recipeid = recipesLinkIngredients.recipeid right outer join ingredients i on recipesLinkIngredients.ingredientID = i.ingredientID where r.recipeid=" + Request.QueryString["key"];
reader = comm.ExecuteReader();
categoryTable.Load(reader);
// load category list data
comm.Parameters.Clear();
comm.CommandText = "select categoryid, type from categories";
reader = comm.ExecuteReader();
listTable.Load(reader);
// bind category label (normal mode) and category droplist (edit mode)
Label category = (Label)DetailsViewDetail.FindControl("catgoryLabel");
if (category != null)
{
category.Text = categoryTable.Rows[0]["type"].ToString();
}
DropDownList categoryDropList = (DropDownList)DetailsViewDetail.FindControl("categoryList");
if (categoryDropList != null)
{
categoryDropList.DataSource = listTable;
categoryDropList.DataTextField = "Type";
categoryDropList.DataValueField = "categoryid";
categoryDropList.DataBind();
ListItem selectedListItem = categoryDropList.Items.FindByValue(categoryTable.Rows[0]["categoryid"].ToString());
if (selectedListItem != null)
{
selectedListItem.Selected = true;
}
}
// load ingredients data
comm.Parameters.Clear();
comm.CommandText = "select ingredients.ingredientid,ingredients.name,ingredients.quantity,ingredients.unitofmeasure from ingredients join recipesLinkIngredients on ingredients.INGREDIENTID = recipesLinkIngredients.INGREDIENTID where recipesLinkIngredients .recipeid = " + Request.QueryString["key"];
reader = comm.ExecuteReader();
ingredientsTable.Load(reader);
// bind ingredientView
ingredientView.DataSource = ingredientsTable;
ingredientView.DataBind();
}
catch (SqlException ex)
{
exception.Text = ex.Message;
}
catch (Exception ex)
{
exception.Text = ex.Message;
}
finally
{
comm.Connection.Close();
}
}