错误信息:
ConnectionString 属性尚未初始化。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.InvalidOperationException: ConnectionString 属性尚未初始化。源错误: 执行当前 Web 请求期间生成了未处理的异常。可以使用下面的异常堆栈跟踪信息确定有关异常原因和发生位置的信息。
我是从一个页面链到另一个页面出现的错误.
代码如下:
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;public partial class User_OrderDetail : System.Web.UI.Page
{
string strSql;
WebService webService = new WebService();
string oid;
DataTable dtTable; protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserLevel"] == null || Session["UserLevel"].ToString() != "User")
{
Response.Redirect("error.aspx");
}
oid = Request.QueryString["oid"].ToString();
strSql = "select * from OrderInfo where(Order_no='" + oid + "');";
dtTable = webService.ExcuteSelect(strSql);
this.lblName.Text = dtTable.Rows[0]["Order_recUserName"].ToString();
this.lblEmail.Text = dtTable.Rows[0]["Order_email"].ToString();
//this.lblPhone.Text = dtTable.Rows[0]["Order_phone"].ToString();
this.lblAddress.Text = dtTable.Rows[0]["Order_address"].ToString();
this.lblZip.Text = dtTable.Rows[0]["Order_zip"].ToString();
if (dtTable.Rows[0]["Order_isConfirm"].ToString() == "y")
{
this.lblIsConfirm.Text = "已确认";
string sql="select Admin_name from AdminInfo where Admin_ID='"+dtTable .Rows [0]["Admin_confirmAdminID"].ToString ()+"';";
DataTable table=new DataTable ();
table =webService .ExcuteSelect (sql);
this.lblConfirmAdmin .Text =table .Rows [0]["Admin_name"].ToString ();
this.lblConfirmTime .Text =dtTable .Rows [0]["Order_confirmTime"].ToString ();
}
else
{
this.lblIsConfirm .Text ="未确认";
this.lblConfirmAdmin.Text ="未确认";
this.lblConfirmTime.Text ="未确认";
}
if(dtTable .Rows [0]["Order_sendStatus"].ToString ()=="0")
{
this.lblSendStatus .Text ="未发送"; }
else if(dtTable .Rows [0]["Order_sendStatus"].ToString ()=="1")
{
this.lblSendStatus .Text ="已发送";
}
else
{
this.lblSendStatus .Text ="已签收";
}
}
ConnectionString 属性尚未初始化。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.InvalidOperationException: ConnectionString 属性尚未初始化。源错误: 执行当前 Web 请求期间生成了未处理的异常。可以使用下面的异常堆栈跟踪信息确定有关异常原因和发生位置的信息。
我是从一个页面链到另一个页面出现的错误.
代码如下:
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;public partial class User_OrderDetail : System.Web.UI.Page
{
string strSql;
WebService webService = new WebService();
string oid;
DataTable dtTable; protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserLevel"] == null || Session["UserLevel"].ToString() != "User")
{
Response.Redirect("error.aspx");
}
oid = Request.QueryString["oid"].ToString();
strSql = "select * from OrderInfo where(Order_no='" + oid + "');";
dtTable = webService.ExcuteSelect(strSql);
this.lblName.Text = dtTable.Rows[0]["Order_recUserName"].ToString();
this.lblEmail.Text = dtTable.Rows[0]["Order_email"].ToString();
//this.lblPhone.Text = dtTable.Rows[0]["Order_phone"].ToString();
this.lblAddress.Text = dtTable.Rows[0]["Order_address"].ToString();
this.lblZip.Text = dtTable.Rows[0]["Order_zip"].ToString();
if (dtTable.Rows[0]["Order_isConfirm"].ToString() == "y")
{
this.lblIsConfirm.Text = "已确认";
string sql="select Admin_name from AdminInfo where Admin_ID='"+dtTable .Rows [0]["Admin_confirmAdminID"].ToString ()+"';";
DataTable table=new DataTable ();
table =webService .ExcuteSelect (sql);
this.lblConfirmAdmin .Text =table .Rows [0]["Admin_name"].ToString ();
this.lblConfirmTime .Text =dtTable .Rows [0]["Order_confirmTime"].ToString ();
}
else
{
this.lblIsConfirm .Text ="未确认";
this.lblConfirmAdmin.Text ="未确认";
this.lblConfirmTime.Text ="未确认";
}
if(dtTable .Rows [0]["Order_sendStatus"].ToString ()=="0")
{
this.lblSendStatus .Text ="未发送"; }
else if(dtTable .Rows [0]["Order_sendStatus"].ToString ()=="1")
{
this.lblSendStatus .Text ="已发送";
}
else
{
this.lblSendStatus .Text ="已签收";
}
}
解决方案 »
- webservice问题
- 前台循环DataTable,用string类型接受,循环里面出了问题,请各位高手帮忙解决一下。谢谢了! [.NET技术 ASP.NET]
- 【提问】问一个关于fckEditor2.6版本的上传问题~!
- js传参数问题
- 后台提交页面后无法获取返回数据求解!烦请过去帮忙看下可否?
- vs2005 调试的时候,端口总是和虚拟的端口差几个数,无法调试
- 清除病毒后,.net的csc.exe程序启动失败,提示内存非法操作,如何解决?多谢。
- 关于用户控件的问题
- ASP.net如何连接DSN
- 关于GridView标题头加下拉框的问题
- AJAX Control Toolkit里两个控件的问题
- 如何让DataGrid中多选按钮可以用javascript实现点一个实现全部点中
<appSettings>
<add key="strconnection" value="server=localhost;database=T_eshop;uid=sa;pwd=cwg" />
</appSettings>
<connectionStrings>
<add name="EshopConnection" connectionString="Server=(local)\SqlExpress;Integrated Security=true;Database=T_eshop" providerName ="System.Data.SqlClient"/>
</connectionStrings
有问题吗
public DataTable ExcuteSelect(string strSql)
{
string strConn = "server=.;database=T_eshop;uid=sa;pwd=cwg";
DbProviderFactory dbProviderFactory = DbProviderFactories.GetFactory("System.Data.SqlClient");
DbConnection dbConn = dbProviderFactory.CreateConnection();
dbConn.ConnectionString = strConn;
dbConn.Open();
DbCommand dbComm = dbProviderFactory.CreateCommand();
dbComm.Connection = dbConn;
dbComm.CommandText = strSql;
DbDataAdapter adapter = dbProviderFactory.CreateDataAdapter();
adapter.SelectCommand = dbComm;
DataSet dsDataSet = new DataSet();
adapter.Fill(dsDataSet, "table");
return dsDataSet.Tables["table"]; }
<?xml version="1.0"?>
<configuration>
<appSettings>
<add key="strConn" value="workstation id=All;packet size=4096;UID=sa;data source=(local);persist security info=True;initial catalog=123;Max Pool Size=500;Min Pool Size=5"/>
</appSettings> 对一下这句连接的是不是你的strconnection,以下是我的配置
SqlConnection myConnection=new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
SqlConnection myConnection=new SqlConnection(ConfigurationSettings.AppSettings["strConn"]);
好像还是不行呀