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

来源：互联网发布：excel怎么找出相同数据编辑：程序博客网时间：2024/05/01 16:58

总结:

今天用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> 下面。