protected void btnYes_Click(object sender, EventArgs e) { try { //ItemsGridView.DeleteRow(ItemsGridView.SelectedIndex); GridDataItem item = (GridDataItem)ItemsGridView.SelectedItems[0]; //JC_ID,BOM_ID string jc_id = item.GetDataKeyValue("JC_ID").ToString(); string bom_id = item.GetDataKeyValue("SPL_ID").ToString(); dsErectionTableAdapters.VIEW_SITE_JC_SPLTableAdapter rec = new VIEW_SITE_JC_SPLTableAdapter(); rec.DeleteQuery(decimal.Parse(jc_id), decimal.Parse(bom_id)); Master.ShowMessage("Spool deleted"); ItemsGridView.Rebind(); } catch (Exception ex) { Master.ShowWarn(ex.Message); } }
protected void btnAddSpool_Click(object sender, EventArgs e) { VIEW_SITE_JC_SPLTableAdapter jc_items = new VIEW_SITE_JC_SPLTableAdapter(); try { jc_items.InsertQuery(decimal.Parse(Request.QueryString["JC_ID"]), decimal.Parse(cboNewSpool.SelectedValue), string.Empty, string.Empty, string.Empty); ItemsGridView.DataBind(); Master.ShowMessage("Spool added."); } catch (Exception ex) { Master.ShowWarn(ex.Message); } finally { jc_items.Dispose(); } }