有人遇到这个情况吗?
前台代码
<asp:repeater ID="repeater_producttype" runat="server">
<ItemTemplate >
<span style ="font-weight :bold "><%#Eval ("producttype_name") %></span>
<ul>
<asp:Repeater ID="repeater_smallproducttype" runat ="server" DataSource ='<%#Getsmall(Eval("producttpe_id").ToString()) %>'>
<ItemTemplate >
<li><%#Eval("smllproducttype_name") %></li>
</ItemTemplate>
</asp:Repeater>
</ul>
</ItemTemplate>
</asp:repeater>
cs代码
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
BindGrid();
}
//获取大类的类别
protected void BindGrid()
{
string str = "select pid, pname from pro";
Datatable dt = helpchg.GetDataTable(str );
Repeater1.DataSource = dt;
Repeater1.DataBind();
}
//获取小类内容
protected DataTable Getsmall(string id)
{
string str = "select city_name from city where promo_id = " + id + "";
DataTable dt = helpchg.GetDataTable(str);
return dt;
}
数据库链接代码:
using 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;
namespace help2{
/// <summary>
/// SqlHelp 的摘要说明
/// </summary>
public class SqlHelp2
{
public OleDbCommand comm;
OleDbDataReader dr;
string connStr = "";
public OleDbConnection conn;
public SqlHelp2()
{
//string dsd = System.Configuration.ConfigurationManager.ConnectionStrings["Connstr"].ToString();
connStr = "provider=Microsoft.jet.OLEDB.4.0;data Source=" + System.Web.HttpContext.Current.Server.MapPath("App_Data/lvyin.mdb");
}
private void open()
{
conn = new OleDbConnection(connStr);
conn.Open();
}
private void close()
{
conn.Close();
}
public DataSet getds(string str)
{
DataSet ds = new DataSet();
open();
OleDbDataAdapter da = new OleDbDataAdapter(str, conn);
da.Fill(ds);
da.Dispose();
close();
return ds;
}
public int Delete(string str)
{
open();
comm = new OleDbCommand(str, conn);
return comm.ExecuteNonQuery();
}
public OleDbDataReader getDataReader(string str)
{
open();
OleDbCommand cmd = new OleDbCommand(str, conn);
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
public int Insert(string str)
{
open();
OleDbCommand cmd = new OleDbCommand(str, conn);
return cmd.ExecuteNonQuery();
}
}
}