.net oracle 结果集,请教：为何调用Oracle过程返回结果集后用GridView显示不出来数据...

当前位置:我的异常网» ASP.NET » 请教：为何调用Oracle过程返回结果集后用GridView显

请教：为何调用Oracle过程返回结果集后用GridView显示不出来数据

www.myexceptions.net，网友分享于：2013-01-01   浏览：33次

请问：为何调用Oracle过程返回结果集后用GridView显示不出来数据

按网上说的做的一例子：

C#部分：

using   System;

using   System.Data;

using   System.Configuration;

using   System.Collections;

using   System.Web;

using   System.Web.Security;

using   System.Web.UI;

using   System.Web.UI.WebControls;

using   System.Web.UI.WebControls.WebParts;

using   System.Web.UI.HtmlControls;

using   System.Data.OracleClient;

public   partial   class   CallProcedure   :   System.Web.UI.Page

{

public   string   bmsOracleUser   =   "test_user ";

public   string   bmsOracleConnectionString   =   "Data   Source=test;user   id=test_user;password=test_user ";

protected   void   Page_Load(object   sender,   EventArgs   e)

{

if   (!IsPostBack)

{

DataSet   ds   =   new   DataSet();

ds   =   Bill_Point_No(44);

if   (ds.Tables.Count   >   0)

{

GridView1.DataSource   =   ds;

GridView1.DataBind();

}

else

{

Response.Write( "Unable   to   connect   to   the   database ");

}

}

}

public   DataSet   Bill_Point_No(int   CUSTOMER_ID)

{

DataSet   dataset   =   new   DataSet();

Hashtable   HT   =   new   Hashtable();

HT.Add( "P_CUSTOMER_ID ",   CUSTOMER_ID);

if   (RunProcedure( "Re_CURSOR ",   OracleType.Cursor,   ref   dataset,   HT,   bmsOracleUser   +   ".YY_PKG_BILL_POINT_NO.BILL_POINT_NO ",   bmsOracleConnectionString))

{

;

}

else

相关解决方案

暂无相关解决方案