protected void Page_Load(object sender, EventArgs e) { sql = new BatchofSupplies(); sql.Open(); if (!IsPostBack) { SqlDataReader drrr = sql.GetBatchSupply(); Grid1.DataSource = drrr; Grid1.DataBind(); drrr.Close(); SqlDataReader dr1 = sql.GetSupply(); ddlbs.DataSource = dr1; ddlbs.DataTextField = "Name"; ddlbs.DataValueField = "Name"; ddlbs.DataBind(); dr1.Close(); exdate.Text = DateTime.Now.ToShortDateString(); } }
protected void Page_Load(object sender, EventArgs e) { sql = new BatchofSupplies(); sql.Open(); SqlDataReader drrr = sql.GetBatchSupply(); GridView1.DataSource = drrr; GridView1.DataBind(); drrr.Close(); }
protected void ImageButton14_Click(object sender, ImageClickEventArgs e) { //sql = new BatchofSupplies(); sql.Open(); //sql.AddBatchSupply(ddlbs.SelectedValue, int.Parse(qty.Text), DateTime.Parse(exdate.Text)); validation v1 = new validation(); v1.Quantity = int.Parse(qty.Text); v1.Date = DateTime.Parse(exdate.Text); sql.AddBatchSupply(ddlbs.SelectedValue, int.Parse(qty.Text), DateTime.Parse(exdate.Text)); SqlDataReader daa = sql.GetBatchSupply(); Grid1.DataSource = daa; Grid1.DataBind(); sql.Close(); }