protected void Button1_Click(object sender, EventArgs e) { connection con = new connection(); GridView1.DataSource = con.DisplayData("sp_report_expiry", "", endDate.Text, ""); GridView1.DataBind(); panelVisibility(); }
protected void Button1_Click(object sender, EventArgs e) { connection con = new connection(); GridView1.DataSource = con.DisplayData("sp_report_purchaseReturn", startDate.Text, endDate.Text, ""); GridView1.DataBind(); panelVisibility(); //double tot = 0; //for (int i = 0; i < GridView1.Rows.Count; i++) //{ // tot += Convert.ToDouble(GridView1.Rows[i].Cells[4].Text); //} //lblTotal.Text = "Rs. " + tot; }
protected void Button1_Click(object sender, EventArgs e) { connection con = new connection(); GridView1.DataSource = con.DisplayData("sp_report_medicineWiseExpiry", startDate.Text, endDate.Text, DDMedicineName.SelectedValue); GridView1.DataBind(); panelVisibility(); //double tot = 0; //for(int i=0; i<GridView1.Rows.Count; i++) //{ // tot += Convert.ToDouble(GridView1.Rows[i].Cells[2].Text); //} //lblTotal.Text = "Rs. " + tot; }
protected void Button1_Click(object sender, EventArgs e) { connection con = new connection(); GridView1.DataSource = con.DisplayData("sp_report_doctorWiseSales", startDate.Text, endDate.Text, DDDoctorName.SelectedValue); GridView1.DataBind(); panelVisibility(); double tot = 0; for (int i = 0; i < GridView1.Rows.Count; i++) { tot += Convert.ToDouble(GridView1.Rows[i].Cells[2].Text); } lblTotal.Text = "Rs. " + tot; }