repeater 数据绑定 , webconfig 数据库连接字符串出现的问题

最新推荐文章于 2024-11-15 22:11:31 发布

kk5595

最新推荐文章于 2024-11-15 22:11:31 发布

阅读量924

点赞数

文章标签：数据库 server dataset security xhtml cmd

本文链接：https://blog.csdn.net/kk5595/article/details/6555180

版权

总结:

今天用reperater 做个例子，可是数据库连接webconfig 老出问题。最终解决办法: webconfig 不需要转义字符，即/ 不需要用//

<connectionStrings>
<add name="con_str" connectionString="Server=9BB88DD1B0874BD/SQLEXPRESS;Integrated Security=SSPI;Database=mydata" providerName="System.Data.SqlClient"/> // 注意值里不要有转义的//

</connectionStrings>

cs页面调用:ConfigurationManager.ConnectionStrings["con_str"].ConnectionString;

Aspx页面

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>无标题页</title> </head> <body> <form id="form1" runat="server"> <div> <asp:Repeater ID="repeater1" runat="server"> <HeaderTemplate> <table> <tr><th>姓名</th><th>成绩</th></tr> </HeaderTemplate> <ItemTemplate> <tr> <td><asp:Label runat="server" ID="label1" Text='<%#Eval("sname") %>'></asp:Label></td> <td><asp:Label runat="server" ID="lable2" Text='<%#Eval("score") %>'></asp:Label></td> </tr> </ItemTemplate> </asp:Repeater> </table> </div> </form> </body> </html>

Aspx.cs页面using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { //SqlConnection con = new SqlConnection("Server=9BB88DD1B0874BD//SQLEXPRESS;Integrated Security=SSPI;Database=mydata"); //string a = ConfigurationSettings.AppSettings["con_str"].ToString(); //ConfigurationManager string a = ConfigurationManager.ConnectionStrings["con_str"].ConnectionString; SqlConnection con = new SqlConnection(a); con.Open(); SqlCommand cmd = new SqlCommand("select * from student", con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); this.repeater1.DataSource = ds; this.repeater1.DataBind(); } }

web.config

数据库字符串连接放在 <configuration> 下面。