<%@ Page Language="c#" debug="true" %>
<%@ Import Namespace="System.IO" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb"%>
<script language="c#" runat="server">
public OleDbConnection conn;
public OleDbConnection GetConnect()
{
string connStr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("db/global.asa");
conn=new OleDbConnection(connStr);
return conn;
}
public DataSet GetDataSet(String sql)
{
conn=GetConnect();
conn.Open();
DataSet ds=new DataSet();
OleDbDataAdapter oleda=new OleDbDataAdapter(sql,conn);
oleda.Fill(ds);
return ds;
}public void Page_Load(object sender,System.EventArgs e)
{
string sql="select * from article where classid=69";
xinxi.DataSource=GetDataSet(sql);
xinxi.DataBind();
xinxi.Dispose();
}
</script>
调用的时候是这样子的
<table width="178" border="0" align="center" cellpadding="0" cellspacing="5" bgcolor="#F1F0EB">
<tr>
<td width="10">
<asp:DataList id="chengren" runat="server" CellSpacing="0" ShowFooter="False" ShowHeader="False">
<ItemTemplate>
<template name="itemtemplate">
<img src="images/biao_sj.gif" width="3" height="5">
<%# DataBinder.Eval(Container, "DataItem.title") %>
</template>
</ItemTemplate>
</asp:DataList>
</td>
</tr>
</table>
<%@ Import Namespace="System.IO" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb"%>
<script language="c#" runat="server">
public OleDbConnection conn;
public OleDbConnection GetConnect()
{
string connStr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("db/global.asa");
conn=new OleDbConnection(connStr);
return conn;
}
public DataSet GetDataSet(String sql)
{
conn=GetConnect();
conn.Open();
DataSet ds=new DataSet();
OleDbDataAdapter oleda=new OleDbDataAdapter(sql,conn);
oleda.Fill(ds);
return ds;
}public void Page_Load(object sender,System.EventArgs e)
{
string sql="select * from article where classid=69";
xinxi.DataSource=GetDataSet(sql);
xinxi.DataBind();
xinxi.Dispose();
}
</script>
调用的时候是这样子的
<table width="178" border="0" align="center" cellpadding="0" cellspacing="5" bgcolor="#F1F0EB">
<tr>
<td width="10">
<asp:DataList id="chengren" runat="server" CellSpacing="0" ShowFooter="False" ShowHeader="False">
<ItemTemplate>
<template name="itemtemplate">
<img src="images/biao_sj.gif" width="3" height="5">
<%# DataBinder.Eval(Container, "DataItem.title") %>
</template>
</ItemTemplate>
</asp:DataList>
</td>
</tr>
</table>
xinxi.DataBind();
xinxi.Dispose();
<asp:DataList id="chengren" runat="server" CellSpacing="0" ShowFooter="False" xinxi?
chengren?
在数据库中运行一下,看是不是只有一条数据。
{
string sql="select * from article";
xinxi.DataSource=GetDataSet(sql);
xinxi.DataBind();
xinxi.Dispose();
}