예제 #1
0
    protected void Search_Click(object sender, EventArgs e)
    {
        //***** GET DATASET
        Koneksi  cn             = new Koneksi();
        DataSet  ds             = new DataSet();
        string   date1          = TxtAwal.Text;
        DateTime formattedtime1 = DateTime.ParseExact(date1, "dd/MM/yyyy", CultureInfo.InvariantCulture);
        string   date2          = TxtAkhir.Text;
        DateTime formattedtime2 = DateTime.ParseExact(date2, "dd/MM/yyyy", CultureInfo.InvariantCulture);

        string sql = "Select * from Stock where TglDatang >= '" + date1 + "' and TglDatang <= '" + date2 + "' ";

        ds = cn.getDataSet(sql);

        ListViewMasterStock.DataSource = ds;
        ListViewMasterStock.DataBind();
    }
예제 #2
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["Member_ID"] == null)
        {
            Response.Redirect("~/Login.aspx");
        }


        ListViewMasterStock.DataSource = null;
        ListViewMasterStock.DataBind();

        //***** GET DATASET
        //Koneksi cn = new Koneksi();
        //DataSet ds = new DataSet();
        //string sql = "Select * from Stock";
        //ds = cn.getDataSet(sql);

        //ListViewMasterStock.DataSource = ds;
        //ListViewMasterStock.DataBind();
    }