public void LoadData() { try { DataTable dt; DAC_Stock oDAC_Stock = new DAC_Stock(); dt = oDAC_Stock.Select(); String StrInnserHtml = ""; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { StrInnserHtml = StrInnserHtml + "<tr><td>" + dt.Rows[i][1].ToString() + "</td><td>" + dt.Rows[i][2].ToString() + "</td><td>" + dt.Rows[i][3].ToString() + "</td><td>" + dt.Rows[i][4].ToString() + "</td><td>" + dt.Rows[i][5].ToString() + "</td><td>" + dt.Rows[i][6].ToString() + "</td></tr>"; } } divInnerHtml.InnerHtml = StrInnserHtml; } catch (Exception ex) { throw; } }
protected void btnupdate_Click(object sender, EventArgs e) { REF_Stock oREF_Stock = new REF_Stock(); DAC_Stock oDAC_Stock = new DAC_Stock(); oREF_Stock.ID = StockID; oREF_Stock.ItemID = ItemName.Text; int Qty = Convert.ToInt32(Quentity.Text) + Convert.ToInt32(newQty.Text); oREF_Stock.Qty = Qty.ToString(); oDAC_Stock.Update(oREF_Stock); Response.Redirect("./frmStock.aspx", true); }
public void LoadData(REF_Stock oREF_Stock) { try { DataTable dt; DAC_Stock oDAC_Stock = new DAC_Stock(); dt = oDAC_Stock.SelectStockID(oREF_Stock); ItemName.Enabled = false; ItemName.Text = dt.Rows[0][1].ToString(); Quentity.Text = dt.Rows[0][2].ToString(); } catch (Exception ex) { throw; } }
protected void btnsave_Click(object sender, EventArgs e) { try { REF_Stock oREF_Stock = new REF_Stock(); DAC_Stock oDAC_Stock = new DAC_Stock(); oREF_Stock.ItemID = dropItem.Value; oREF_Stock.Qty = Quentity.Text; oDAC_Stock.Insert(oREF_Stock); Response.Redirect("./frmStock.aspx", true); } catch (Exception ex) { ShowMessage("Something went wrong! Please try again!"); } }