在我的网格中看不到任何值我的查询正常工作但数据集为空。 [英] Cannot see any Values in my grid my query works properly but dataset is empty.

问题描述

  protected   void  dgBrows_ItemDataBound（对象发​​件人，DataGridItemEventArgs e）
 {
  //   e。 Item.Attributes.Add（onmouseover，this.style.cursor ='pointer'）;  
  //   e.Item.Attributes [onclick] =javascript：window.location.href ='usergroup_form.aspx？Sel_Mode = edit& pass_val =+ e.Item.Cells [0] .Text .Trim（）+& slip_no =+ e.Item.Cells [1] .Text.Trim（）+';  
 
 e.Item.Attributes [< span class =code-string>  onmouseover] =   this.style.cursor = '指针'; this.style.textDecoration = '下划线';; 
 e.Item.Attributes [  onmouseout] =   this.style.textDecoration ='none';; 
 e.Item.ToolTip =  点击选择行; 
  string  internalID = e.Item.Cells [ 0 ]。Text.Trim（）; 
 e.Item.Attributes.Add（  onclick，  GridViewEditSelect（'UserGroup_Form'，'EDIT'，' + internalID +  '））; 
 
} 

公共字符串search_Query（）

{

StringBuilder sb = new StringBuilder（）;

sb = new StringBuilder（）;

sb.Append（SELECT ）;

sb.Append（TO_CHAR（USER_GROUP.ID）ID，）;

sb.Append（USER_GROUP.SHORTNAME，）;

sb.Append（USER_GROUP.FIRST_NAME）;

sb.Append（FROM USER_GROUP）;

sb.Append（WHERE）;

sb.Append（USER_GROUP.USER_GROUPTYPE ='G'和COMPANY_ID =：i_COMPANY_ID AND）;

sb.Append（UPPER（SHORTNAME）喜欢上层（： COL_VALUE））;

sb.Append（ORDER BY USER_GROUP.ID DESC）;



返回sb.ToString（）;

}



public DataSet ds_search_query（string search_text，string col_name，int tPageNo，int Company_ID）

{

ds = null;

MySql = search_Query（）;

int Starting_Range =（tPageNo - 1）* 10 + 1;

int Ending_Range =（tPageNo * 10）+ 1;

t_sql =SELECT * FROM（SELECT A. *，ROWNUM RNUM FROM （+ MySql +）A WHERE ROWNUM< ：Ending_Range）其中rnum> =：Starting_Range;



s_dsnstr = o_Cls_Utility.utl_fnGetDSNStr（SessionHandle.Current.SessionCompanyCode）;

OracleConnect o_Cls_OracleConnect = new OracleConnect（s_dsnstr）;

o_Cls_OracleConnect.OracleCommand_PreInit（t_sql）;

o_Cls_OracleConnect.Parameter_Int32（i_COMPANY_ID，Company_ID）;

//o_Cls_OracleConnect.Parameter_Int32(\"DP_LIST_ID，t_DP_LIST_ID）;

o_Cls_OracleConnect.Parameter_StringLike（COL_VALUE，search_text）;

o_Cls_OracleConnect.Parameter_Int32（Starting_Range，Starting_Range） ;

o_Cls_OracleConnect.Parameter_Int32（Ending_Range，Ending_Range）;



ds = o_Cls_OracleConnect.GetDataSet（）;

返回ds;

}

  public   int  search_fullquery（ string  search_text， string  col_name，< span class =code-keyword> int  pageno， int  Company_ID）
 {
 MySql = search_Query（）; 
 returnCount =  0 ; 
 
  if （MySql.IndexOf（  UNION）>   0  || MySql.IndexOf（  _ FROM）>   0  || MySql.IndexOf（  FROM _）>   0 ）
 {
 t_sql =   SELECT COUNT（*）FROM（ + MySql +  ）; 
} 
  else  
 {
 t_sql =   SELECT COUNT（*） + MySql.Substring（MySql.IndexOf（  FROM））; 
} 
 
 s_dsnstr = o_Cls_Utility.utl_fnGetDSNStr（SessionHandle.Current.SessionCompanyCode）; 
 OracleConnect o_Cls_OracleConnect =  new  OracleConnect（s_dsnstr）; 
 
 o_Cls_OracleConnect.OracleCommand_PreInit（t_sql）; 
 o_Cls_OracleConnect.Parameter_Int32（  i_COMPANY_ID，Company_ID）; 
 o_Cls_OracleConnect.Parameter_StringLike（  COL_VALUE，search_text）; 
 
 returnCount = Convert.ToInt32（o_Cls_OracleConnect.ExecuteScalar（））; 
  return  returnCount; 
} 

解决方案

可能是你的LIKE条款：检查你的 search_text 并确保它包含SQL通配符值，例如'％'。



如果没有，那么

 MyColumn  LIKE  '  mystring' 

与

 MyColumn = '  mystring'  

protected void dgBrows_ItemDataBound(object sender, DataGridItemEventArgs e)
      {
          //e.Item.Attributes.Add("onmouseover", "this.style.cursor='pointer'");
          //e.Item.Attributes["onclick"] = "javascript:window.location.href='usergroup_form.aspx?Sel_Mode=edit&pass_val=" + e.Item.Cells[0].Text.Trim() + "&slip_no=" + e.Item.Cells[1].Text.Trim() + "'";

              e.Item.Attributes["onmouseover"] = "this.style.cursor='pointer';this.style.textDecoration='underline';";
              e.Item.Attributes["onmouseout"] = "this.style.textDecoration='none';";
              e.Item.ToolTip = "Click to select row";
              string internalID = e.Item.Cells[0].Text.Trim();
              e.Item.Attributes.Add("onclick", "GridViewEditSelect('UserGroup_Form', 'EDIT', '" + internalID + "')");

      }

public string search_Query()
{
StringBuilder sb = new StringBuilder();
sb = new StringBuilder();
sb.Append(" SELECT ");
sb.Append(" TO_CHAR(USER_GROUP.ID) ID, ");
sb.Append(" USER_GROUP.SHORTNAME,");
sb.Append(" USER_GROUP.FIRST_NAME ");
sb.Append(" FROM USER_GROUP ");
sb.Append(" WHERE ");
sb.Append(" USER_GROUP.USER_GROUPTYPE = 'G' AND COMPANY_ID = :i_COMPANY_ID AND ");
sb.Append(" UPPER(SHORTNAME) LIKE UPPER(:COL_VALUE) ");
sb.Append(" ORDER BY USER_GROUP.ID DESC");

return sb.ToString();
}

public DataSet ds_search_query(string search_text, string col_name, int tPageNo , int Company_ID)
{
ds = null;
MySql = search_Query();
int Starting_Range = (tPageNo - 1) * 10 + 1;
int Ending_Range = (tPageNo * 10) + 1;
t_sql = "SELECT * FROM (SELECT A.*, ROWNUM RNUM FROM ( " + MySql + " ) A WHERE ROWNUM < :Ending_Range) where rnum >= :Starting_Range";

s_dsnstr = o_Cls_Utility.utl_fnGetDSNStr(SessionHandle.Current.SessionCompanyCode);
OracleConnect o_Cls_OracleConnect = new OracleConnect(s_dsnstr);
o_Cls_OracleConnect.OracleCommand_PreInit(t_sql);
o_Cls_OracleConnect.Parameter_Int32("i_COMPANY_ID", Company_ID);
//o_Cls_OracleConnect.Parameter_Int32("DP_LIST_ID", t_DP_LIST_ID);
o_Cls_OracleConnect.Parameter_StringLike("COL_VALUE", search_text);
o_Cls_OracleConnect.Parameter_Int32("Starting_Range", Starting_Range);
o_Cls_OracleConnect.Parameter_Int32("Ending_Range", Ending_Range);

ds = o_Cls_OracleConnect.GetDataSet();
return ds;
}

public int search_fullquery(string search_text, string col_name, int pageno, int Company_ID)
       {
           MySql = search_Query();
           returnCount = 0;

           if (MySql.IndexOf("UNION") > 0 || MySql.IndexOf("_FROM") > 0 || MySql.IndexOf("FROM_") > 0)
           {
               t_sql = "SELECT COUNT(*) FROM ( " + MySql + " )";
           }
           else
           {
               t_sql = "SELECT COUNT(*) " + MySql.Substring(MySql.IndexOf("FROM"));
           }

           s_dsnstr = o_Cls_Utility.utl_fnGetDSNStr(SessionHandle.Current.SessionCompanyCode);
           OracleConnect o_Cls_OracleConnect = new OracleConnect(s_dsnstr);

           o_Cls_OracleConnect.OracleCommand_PreInit(t_sql);
           o_Cls_OracleConnect.Parameter_Int32("i_COMPANY_ID", Company_ID);
           o_Cls_OracleConnect.Parameter_StringLike("COL_VALUE", search_text);

           returnCount = Convert.ToInt32(o_Cls_OracleConnect.ExecuteScalar());
           return returnCount;
       }

解决方案

Probably, it's your LIKE clause: check your search_text and make sure it contains SQL wildcard values such as '%'.

If it doesn't, then

MyColumn LIKE 'mystring'

is the same as

MyColumn = 'mystring'

这篇关于在我的网格中看不到任何值我的查询正常工作但数据集为空。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！