数据库导出Excel问题！！急！！不解决就不睡觉！！

[yc04740163]

我想把数据库中的数据以Excel文件的格式显示在浏览器中，写了下面的代码：

页面有一个id号为dgExcel的datagrid

后台代码为：
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
String strSQL;
DataSet objDataSet = new DataSet();

SqlConnection objConn = new SqlConnection (System.Configuration.ConfigurationSettings.AppSettings.Get("ConnectionString"));
objConn = new SqlConnection();
try
{
objConn.Open();
SqlDataAdapter objAdapter = new SqlDataAdapter();
strSQL = "Selcte * from mrBaseInf";
objAdapter.SelectCommand = new SqlCommand(strSQL , objConn);
objAdapter.Fill(objDataSet);

DataView oView = new DataView(objDataSet.Tables[0]);
dgExcel.DataSource = oView;
dgExcel.DataBind();
objConn.Close();
objConn.Dispose();
objConn = null;
}
catch(Exception ex)
{
throw new ApplicationException(ex.ToString());
}

if(Request.QueryString["bExcel"]=="1")
{
Response.ContentType="application/vnd.ms-excel";
Response.Charset="";
EnableViewState = false;
System.IO.StringWriter tw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
dgExcel.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();

}


}

-----------------------------------------------------------------------------------------
我已打开这页就报下面的信息：

错误消息： System.InvalidOperationException: The ConnectionString property has not been initialized. at System.Data.SqlClient.SqlConnection.Open() at qminoa.Webs.MR.yc.Page_Load(Object sender, EventArgs e)


各位大虾这是怎么一回事阿？？

[极客行天下]

分开来试试：先绑定数据，在页面上弄一按钮生成EXCEL

[czhenq]

The ConnectionString property has not been initialized

没有设置连接字符串.

看看你配置文件中是否有你要的连接字符串,还是连接字符串不正确

[yc04740163]

可以导出了，是连接字符串没设好。