C# (CSharp) Material_Consumption.Forms Request2 Examples

Example #1

        protected void Page_Load(object sender, EventArgs e)
        {
            sql = new Request2();
            sql.Open();


            if (!IsPostBack)
            {
                SqlDataReader drrr = sql.GetRequestSupplies();
                GridView1.DataSource = drrr;
                GridView1.DataBind();
                drrr.Close();


                SqlDataReader dr1 = sql.GetSupply();

                ddl1.DataSource     = dr1;
                ddl1.DataTextField  = "Name";
                ddl1.DataValueField = "Name";
                ddl1.DataBind();
                dr1.Close();

                lbld.Text = DateTime.Now.ToShortDateString();
            }
        }

Example #2

File: RequestSupply2.aspx.cs Project: antonettejao/Material-Consumption

        protected void Page_Load(object sender, EventArgs e)
        {
            sql = new Request2();
            sql.Open();

            if (!IsPostBack)
            {
                SqlDataReader drrr = sql.GetRequestSupplies();
                GridView1.DataSource = drrr;
                GridView1.DataBind();
                drrr.Close();

                SqlDataReader dr1 = sql.GetSupply();

                ddl1.DataSource = dr1;
                ddl1.DataTextField = "Name";
                ddl1.DataValueField = "Name";
                ddl1.DataBind();
                dr1.Close();

                lbld.Text = DateTime.Now.ToShortDateString();
            }
        }