protected void Page_Load(object sender, EventArgs e)
{
if(!Page .IsPostBack )
{
book bk = new book();
DataList1.DataSource = bk.mymethod("select * from mysinger");
DataList1.DataBind();
}
}
public class book
{
protected string connstring;
public book()
{
connstring = ConfigurationManager.ConnectionStrings["SingerConnectionString"].ConnectionString;
}
public DataTable mymethod(string query)
{
SqlConnection conn = new SqlConnection(connstring );
SqlDataAdapter dap = new SqlDataAdapter(query, conn);
DataSet ds = new DataSet();
dap.Fill(ds,"name");
return ds.Tables["name"]; }
}
web.config里配置为:
<connectionStrings>
<add name="SingerConnectionString" connectionString="Data Source=56b4ce34f93c4f0\sqlexpress;Initial Catalog=Singer;Persist Security Info=True;User ID=sa;Password=12345"
providerName="System.Data.SqlClient" />
</connectionStrings>
数据库,数据表都没问题,连接成功数据库,在设计里加入了datalist空间,运行后竟然是空白页面,也无错误提示,这是怎么回事啊?
{
if(!Page .IsPostBack )
{
book bk = new book();
DataList1.DataSource = bk.mymethod("select * from mysinger");
DataList1.DataBind();
}
}
public class book
{
protected string connstring;
public book()
{
connstring = ConfigurationManager.ConnectionStrings["SingerConnectionString"].ConnectionString;
}
public DataTable mymethod(string query)
{
SqlConnection conn = new SqlConnection(connstring );
SqlDataAdapter dap = new SqlDataAdapter(query, conn);
DataSet ds = new DataSet();
dap.Fill(ds,"name");
return ds.Tables["name"]; }
}
web.config里配置为:
<connectionStrings>
<add name="SingerConnectionString" connectionString="Data Source=56b4ce34f93c4f0\sqlexpress;Initial Catalog=Singer;Persist Security Info=True;User ID=sa;Password=12345"
providerName="System.Data.SqlClient" />
</connectionStrings>
数据库,数据表都没问题,连接成功数据库,在设计里加入了datalist空间,运行后竟然是空白页面,也无错误提示,这是怎么回事啊?
解决方案 »
- 部署iis后不能上传文件...高手帮帮忙啊,在线等...
- ASP.NET如何使用AJAX??
- 有关ueditor(百度编辑器)的问题,见内容!
- webservice 返回的类型
- 新手的问题!关于 对话框
- sqlserver服务器上有两个实例,其中一个是sqlsexpress,一个是sql2000的。连接sql2000实例失败????
- 使用freetextbox 1.6.3,我修改了源代码,请问如何编译成DLL以使用?
- 有用过Spreadsheet的吗?
- 不知道SQl server 如何将字符串转换未日期类型?oracle 可以用 TO_DATE('2004-2-1','YYYY-MM-DD HH24:MI:SS')
- 从数据库中的一列里获取最大的数值,在Default.aspx.cs页面得到。用三层构架,此段方法写在BLL层。
- 等比例缩下图片
- ASP.NET操作ORACLE,CLOB问题。100分~~~
<%#Eval("你查询的字段")%>
</...>
conn.Open();
使用时候要自己定义显示的模板,再绑定数据
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:DataList ID="DataList1" runat="server">
</asp:DataList>
</div>
<p>
</p>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"></asp:SqlDataSource>
</form>
</body>
</html>
<%@ 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:DataList ID="DataList1" runat="server" DataKeyField="SingerID"
DataSourceID="SqlDataSource1" RepeatDirection="Horizontal">
<ItemTemplate>
SingerID:
<asp:Label ID="SingerIDLabel" runat="server" Text='<%# Eval("SingerID") %>' />
<br />
Name:
<asp:Label ID="NameLabel" runat="server" Text='<%# Eval("Name") %>' />
<br />
Sex:
<asp:Label ID="SexLabel" runat="server" Text='<%# Eval("Sex") %>' />
<br />
Stature:
<asp:Label ID="StatureLabel" runat="server" Text='<%# Eval("Stature") %>' />
<br />
Photo:
<asp:Label ID="PhotoLabel" runat="server" Text='<%# Eval("Photo") %>' />
<br />
<br />
</ItemTemplate>
</asp:DataList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:SingerConnectionString %>"
SelectCommand="SELECT * FROM [mysinger]"></asp:SqlDataSource>
</div>
</form>
</body>
</html>
可是为什么用代码绑定,就是显示不出来呢
<asp:DataList ID="DataList" runat="server" >
<ItemTemplate>
<%#Eval("你查询的字段1")%>
</ItemTemplate>
<ItemTemplate>
<%#Eval("你查询的字段2")%>
</ItemTemplate>
</asp:DataList>