protected void DataList_produkty_DeleteCommand(object source, DataListCommandEventArgs e)
{
SqlConnection con;
SqlCommand coman = new SqlCommand();
con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CS"].ConnectionString);
int Ksiazka_ID = (int)DataList_produkty.DataKeys[(int)e.Item.ItemIndex];
coman.Connection = con;
coman.CommandText = "Delete from [Autor_ksiazki] where id_ksiazki=" + Ksiazka_ID;
coman.Connection.Open();
coman.ExecuteNonQuery();
coman.Connection.Close();
coman.Connection = con;
coman.CommandText = "Delete from [Ksiazka] where id_ksiazki=" + Ksiazka_ID;
coman.Connection.Open();
coman.ExecuteNonQuery();
coman.Connection.Close();
DataList_produkty.EditItemIndex = -1;
DataList_produkty.DataBind();
}
protected void DS_Produkty_UpdateCommand(object source, DataListCommandEventArgs e)
{
String ProduktID =
DataList_produkty.DataKeys[e.Item.ItemIndex].ToString();
Int32 ilosc =
int.Parse(((TextBox)e.Item.FindControl("iloscLabel_e")).Text);
SqlDataSource_produkty.UpdateParameters["ProduktID_org"].DefaultValue
= ProduktID;
SqlDataSource_produkty.UpdateParameters["ilosc"].DefaultValue
= ilosc.ToString();
SqlDataSource_produkty.Update();
DataList_produkty.EditItemIndex = -1;
DataList_produkty.DataBind();
}
protected void DS_Produkty_EditCommand(object source, DataListCommandEventArgs e)
{
DataList_produkty.EditItemIndex = e.Item.ItemIndex;
DataList_produkty.DataBind();
}
