Ejemplo n.º 1
0
        protected void btnSearch_Click(object sender, EventArgs e)
        {
            string strCode = ddlSearch.SelectedValue;
            string strSql;

            if (strCode == null || strCode == "" || strCode == "0")
            {
                strSql = "select * from " + strTable + " order by  code";
            }
            else
            {
                strSql = "select * from " + strTable + " start with code='" + strCode + "' connect by prior code = SJCODE order by  code";
            }

            PubFunc.GridDataSet(GridMx, DbHelperOra.Query(strSql).Tables[0]);
        }