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(); }