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