webpart 连接 sql server 显示数据解决方法

webpart 连接 sql server 显示数据

C# code

protected override void RenderContents(HtmlTextWriter writer)        {            base.RenderContents(writer);            string dbStr = default(string);            try            {                                using (SqlConnection connection = new SqlConnection("server=changda;User ID=sa;Password=sa;database=test;Connection Reset=FALSE"))                {                    string strSql = "SELECT * FROM infopathtest";                    SqlDataAdapter sqlData = new SqlDataAdapter(strSql, connection);                    DataTable dt = new DataTable();                    sqlData.Fill(dt);                    dbStr = dt.Rows[0]["name"].ToString();                }                // 如果提交操作成功，则设置                //e.CancelableArgs.Cancel = false;                //System.Web.HttpContext.Current.Response.Write("<script language='javascript'>alert('更新成功！');</script>");            }            catch (Exception ex)            {                string t1 = ex.ToString();            }            String sOutputText = this.Page.Server.HtmlEncode(this.OutputText);            writer.Write("<font color=\"" + this.TextColor.ToString() + "\">" + sOutputText + "</font>");            writer.Write("<br/>");            writer.Write("<font color=\"" + this.TextColor.ToString() + "\">" + dbStr + "</font>");        }

试图在webpart里连接数据库显示数据但提示错误：

C# code

protected override void RenderContents(HtmlTextWriter writer)        {            base.RenderContents(writer);            string dbStr = default(string);            try            {                                using (SqlConnection connection = new SqlConnection("server=changda;User ID=sa;Password=sa;database=test;Connection Reset=FALSE"))                {                    string strSql = "SELECT * FROM infopathtest";                    SqlDataAdapter sqlData = new SqlDataAdapter(strSql, connection);                    DataTable dt = new DataTable();                    sqlData.Fill(dt);                    dbStr = dt.Rows[0]["name"].ToString();                }            }            catch (Exception ex)            {                string t1 = ex.ToString();            }            String sOutputText = this.Page.Server.HtmlEncode(this.OutputText);            writer.Write("<font color=\"" + this.TextColor.ToString() + "\">" + sOutputText + "</font>");            writer.Write("<br/>");            writer.Write("<font color=\"" + this.TextColor.ToString() + "\">" + dbStr + "</font>");        }

[解决办法]
应该webconfig上的配置问题，看看信任级别是否有限制

例如改成
<IPermission class="SqlClientPermission" version="1" Unrestricted="true"/>

 <securityPolicy>
<trustLevel name="Full" policyFile="internal"/>


－－－－－－－－－－－－－－－－－－－－－－－－
另外你的代码看着有点晕，既然只取一个，为什么不top 1

查看更多 下一篇