Ejemplo n.º 1
0
    //Grid
    protected void BindGvY()
    {
        conn.Open();
        string         strSelectCmd = "SELECT * FROM View_Tna_Plan WHERE PO_Ship_Date is NULL  AND ActiveOrder='1' AND TnAapproved IS NOT NULL AND TnaByrNm = '" + dlbuyerY.SelectedItem.Value + "'order by ord_no,po_xfactory ASC";
        SqlDataAdapter da           = new SqlDataAdapter(strSelectCmd, conn);
        DataSet        ds           = new DataSet();

        da.Fill(ds);



        if (ds.Tables[0].Rows.Count == 0)
        {
            ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
            GvY.DataSource = ds;
            GvY.DataBind();
            int columncount = GvY.Rows[0].Cells.Count;
            GvY.Rows[0].Cells.Clear();
            GvY.Rows[0].Cells.Add(new TableCell());
            GvY.Rows[0].Cells[0].ColumnSpan = columncount;
            GvY.Rows[0].Cells[0].Text       = "";
        }
        else
        {
            //Search Option-RUS
            ViewState["dtOrder"] = ds.Tables[0];
            //Search Option-RUS
            GvY.DataSource = ds;
            GvY.DataBind();
        }
    }
Ejemplo n.º 2
0
    protected void BindGvY()
    {
        conn.Open();
        string         strSelectCmd = "SELECT * FROM tbl_problemfollow WHERE done is NULL AND dpt_nm = '" + GetDpt.SelectedItem.Text + "' order by pid ASC";
        SqlDataAdapter da           = new SqlDataAdapter(strSelectCmd, conn);
        DataSet        ds           = new DataSet();

        da.Fill(ds);



        if (ds.Tables[0].Rows.Count == 0)
        {
            ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
            GvY.DataSource = ds;
            GvY.DataBind();
            int columncount = GvY.Rows[0].Cells.Count;
            GvY.Rows[0].Cells.Clear();
            GvY.Rows[0].Cells.Add(new TableCell());
            GvY.Rows[0].Cells[0].ColumnSpan = columncount;
            GvY.Rows[0].Cells[0].Text       = "";
        }
        else
        {
            //Search Option-RUS
            ViewState["dtOrder"] = ds.Tables[0];
            //Search Option-RUS
            GvY.DataSource = ds;
            GvY.DataBind();
        }
    }
Ejemplo n.º 3
0
    //Search Option-RUS
    protected void btnSearch_Click(object sender, EventArgs e)
    {
        DataTable dtOrder = (DataTable)ViewState["dtOrder"];
        DataView  dvOrder = dtOrder.DefaultView;

        dvOrder.RowFilter = "ord_no like '" + txtSearch.Text + "%'";

        GvY.DataSource = dvOrder;
        GvY.DataBind();
    }