using System;
using System.Data;
using System.Data.OracleClient;
using System.Configuration;
using System.IO;
using System.Text;
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;public partial class TCMS_Innovation_CampInnovation_test : System.Web.UI.Page
{
//public OracleConnection oracleConn = new System.Data.OracleClient.OracleConnection(ConfigurationSettings.AppSettings["ConnStr"]);
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Show_CAMP_INTRO();
} }
private void Show_CAMP_INTRO()
{
string cmdText = "select CAMP_NAME from CAMPAIGN_BACE where CAMP_ID=13";
OracleConnection myConnection = new OracleConnection(System.Configuration.ConfigurationManager.AppSettings["ConnStr"]);
OracleCommand myCommand = new OracleCommand(cmdText,myConnection);
string result = "result ";
try
{
myConnection.Open();
Response.Write("koo");
OracleDataReader dr = myCommand.ExecuteReader();
while(dr.Read())
{
result += dr["CAMP_NAME"].ToString();
result += "<br>";
}
dr.Close();
Response.Write(result);
myConnection.Close();
}
catch (Exception ex)
{
}
showintro.Text = result;
sqlcmd.Text = cmdText;
}
}
在设计中Label showintro显示查询结果,返回结果是空的,请问大侠甚么问题
using System.Data;
using System.Data.OracleClient;
using System.Configuration;
using System.IO;
using System.Text;
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;public partial class TCMS_Innovation_CampInnovation_test : System.Web.UI.Page
{
//public OracleConnection oracleConn = new System.Data.OracleClient.OracleConnection(ConfigurationSettings.AppSettings["ConnStr"]);
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Show_CAMP_INTRO();
} }
private void Show_CAMP_INTRO()
{
string cmdText = "select CAMP_NAME from CAMPAIGN_BACE where CAMP_ID=13";
OracleConnection myConnection = new OracleConnection(System.Configuration.ConfigurationManager.AppSettings["ConnStr"]);
OracleCommand myCommand = new OracleCommand(cmdText,myConnection);
string result = "result ";
try
{
myConnection.Open();
Response.Write("koo");
OracleDataReader dr = myCommand.ExecuteReader();
while(dr.Read())
{
result += dr["CAMP_NAME"].ToString();
result += "<br>";
}
dr.Close();
Response.Write(result);
myConnection.Close();
}
catch (Exception ex)
{
}
showintro.Text = result;
sqlcmd.Text = cmdText;
}
}
在设计中Label showintro显示查询结果,返回结果是空的,请问大侠甚么问题
把try catch先注释掉,再执行,看看哪里出错