protected void Button1_Click1(object sender, EventArgs e) { DataAccessClass dac = new DataAccessClass(); DataTable dt1 = dac.SelectDataFromProduct(); GridView1.DataSource = dt1; GridView1.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { string item = DropDownList1.SelectedItem.ToString(); string operat = DropDownList2.SelectedItem.ToString(); string val = TextBox1.Text; DataAccessClass dac = new DataAccessClass(); DataTable dt1 = dac.SearchProducts(item,operat,val); GridView1.DataSource = dt1; GridView1.DataBind(); }
protected void btnSave_Click(object sender, EventArgs e) { int pid = Convert.ToInt32(txtPid.Text); string name = txtPname.Text; decimal price = Convert.ToDecimal(txtPprice.Text); int qty = Convert.ToInt32(txtPqty.Text); DataAccessClass dac = new DataAccessClass(); if (dac.UpdateProduct(pid, name, price, qty)) lblMsg.Text = "Data Update Successfully"; else lblMsg.Text = "Not Updated,, Mising Sometihng,."; }
protected void Button1_Click(object sender, EventArgs e) { int pid =Convert.ToInt32(txtPid.Text); string name = txtPname.Text; decimal price = Convert.ToDecimal(txtPprice.Text); int qty = Convert.ToInt32(txtPqty.Text); DataAccessClass dac = new DataAccessClass(); if (dac.InsertDataIntoProduct(pid, name, price, qty)) lblMsg.Text = "Data Inserted Successfully"; else lblMsg.Text = "Try again Please,."; }
protected void LinkButton1_Click(object sender, EventArgs e) { int pid=Convert.ToInt32(txtPid.Text); DataAccessClass dac = new DataAccessClass(); SqlDataReader reader = dac.SearchProductForEdit(pid); while (reader.Read()) { txtPname.Text = reader.GetString(1); txtPprice.Text = reader.GetValue(2).ToString(); txtPqty.Text =reader.GetInt32(3).ToString(); } }