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