private void button1_Click(object sender, EventArgs e) { oth = ptrl = ent = load = carg = chy = hm = bk = trns = rnt = utity = salry = 0; // string dates = DateTime.Now.ToString(); ds = null; // ds= lgic.search("expence","date",dates); SqlDataReader read = lgic.Readdata("expence", dl_exp_fromdate.Value.ToString(), dl_exp_todate.Value.ToString()); ds = lgic.toFrom("expence", dl_exp_fromdate.Value.ToString(), dl_exp_todate.Value.ToString()); dl_exp_datagrid.DataSource = ds.Tables[0]; // for loop for get data from table while (read.Read()) { string tp = read[1].ToString(); int mnt = Convert.ToInt32(read[3].ToString()); addexpence(tp, mnt); } }
private void sal_srch_daily_Click(object sender, EventArgs e) { ds = lgic.toFrom("perchas", sal_srch_fromdate.Value.ToString(), sal_srch_todate.Value.ToString()); sal_gridview.DataSource = ds.Tables[0]; count(ds); }
private void invn_srch_daily_Click(object sender, EventArgs e) { ds = lgic.toFrom("invoice", invn_srch_fromdate.Value.ToString(), invn_srch_todate.Value.ToString()); invn_gridview.DataSource = ds.Tables[0]; count(ds); }