protected void btnSearch_Click(object sender, EventArgs e) { DataAccessUsingProc dac = new DataAccessUsingProc(); DataTable dt1 = dac.selectProducts(); GridView1.DataSource = dt1; GridView1.DataBind(); }
protected void btnSave_Click(object sender, EventArgs e) { int sd = Convert.ToInt32(txtSupl.Text); string nam = txtName.Text; int qt = Convert.ToInt32(txtQty.Text); decimal pric = Convert.ToDecimal(txtPrice.Text); DataAccessUsingProc dac = new DataAccessUsingProc(); if (dac.InsertProducts(nam, pric, qt, sd)) lblMsg.Text = "New Product Inserted into Inventory.."; else lblMsg.Text = "Product Not Inserted.."; }
protected void btnDelete_Click(object sender, EventArgs e) { int pid = Convert.ToInt32(txtID.Text); DataAccessUsingProc dac = new DataAccessUsingProc(); if (dac.DeleteProducts(pid)) { lblMsg.Text="Product Removed for list.."; } else { lblMsg.Text = "Product Not Removed,,, check your connection.!!!"; } }
protected void LinkButton1_Click(object sender, EventArgs e) { int pid = Convert.ToInt32(txtPid.Text); DataAccessUsingProc dac = new DataAccessUsingProc(); SqlDataReader reader= dac.EditProductForUpdate(pid); while (reader.Read()) { txtName.Text = reader.GetString(1); txtPrice.Text = reader.GetValue(2).ToString(); txtQty.Text = reader.GetInt32(3).ToString(); } }
protected void btnSave_Click(object sender, EventArgs e) { int pid = Convert.ToInt32(txtPid.Text); string nam = txtName.Text; decimal pric = Convert.ToDecimal(txtPrice.Text); int qt = Convert.ToInt32(txtQty.Text); DataAccessUsingProc dac = new DataAccessUsingProc(); if (dac.UpdateProducts(pid, nam, pric, qt)) { lblMsg.Text="Data Update Successfully.."; } else { lblMsg.Text = "Fail.!!!,,,,, Not Updated.."; } }