default.aspx.cs中:
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
db sdb = new db(); DataList1.DataSource = sdb.dt("select top 10 * from t_user"); DataList1.DataBind();
}
}
} <asp:DataList ID="DataList1" runat="server">
<%--<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("userid") %>'></asp:Label>
</ItemTemplate>--%>
</asp:DataList> <br />
<br />
上面注释部分是我上网查的,能显示处userid,但是我是想显示SQL查询的全部内容... webconfig中: <connectionStrings>
<add name="connstring" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Visual Studio 2005\WebSite\datalist1\App_Data\eedb.mdb"
providerName="System.Data.OleDb" />
</connectionStrings>
App_Code中新建 db.csusing System;
using System.Data;
using System.Configuration;
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;
using System.Data.OleDb;
/// <summary>
/// 数据基础操作类
/// </summary>
public class db
{
protected string conString;
public db()
{
conString = ConfigurationManager.ConnectionStrings["constring"].ConnectionString; } public DataTable dt(String query)
{
OleDbConnection conn = new OleDbConnection(conString);
OleDbCommand cmd = new OleDbCommand();
OleDbDataAdapter oda = new OleDbDataAdapter(query,conn);
DataSet ds = new DataSet();
oda.Fill(ds,"name");
return ds.Tables["name"];
}
}估计是conString = ConfigurationManager.ConnectionStrings["constring"].ConnectionString这句的问题,我刚学,那位兄弟能帮帮小弟,看看这咋回事喃?
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
db sdb = new db(); DataList1.DataSource = sdb.dt("select top 10 * from t_user"); DataList1.DataBind();
}
}
} <asp:DataList ID="DataList1" runat="server">
<%--<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("userid") %>'></asp:Label>
</ItemTemplate>--%>
</asp:DataList> <br />
<br />
上面注释部分是我上网查的,能显示处userid,但是我是想显示SQL查询的全部内容... webconfig中: <connectionStrings>
<add name="connstring" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Visual Studio 2005\WebSite\datalist1\App_Data\eedb.mdb"
providerName="System.Data.OleDb" />
</connectionStrings>
App_Code中新建 db.csusing System;
using System.Data;
using System.Configuration;
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;
using System.Data.OleDb;
/// <summary>
/// 数据基础操作类
/// </summary>
public class db
{
protected string conString;
public db()
{
conString = ConfigurationManager.ConnectionStrings["constring"].ConnectionString; } public DataTable dt(String query)
{
OleDbConnection conn = new OleDbConnection(conString);
OleDbCommand cmd = new OleDbCommand();
OleDbDataAdapter oda = new OleDbDataAdapter(query,conn);
DataSet ds = new DataSet();
oda.Fill(ds,"name");
return ds.Tables["name"];
}
}估计是conString = ConfigurationManager.ConnectionStrings["constring"].ConnectionString这句的问题,我刚学,那位兄弟能帮帮小弟,看看这咋回事喃?
<asp:Label ID="Label1" runat="server" Text='<%# Eval("userid") %>'></asp:Label>
</ItemTemplate>--%>
把注释去掉
===========
web.config内是否有constring的配置节点conString = ConfigurationManager.ConnectionStrings["constring"]==null?"":ConfigurationManager.ConnectionStrings["constring"].ConnectionString;