怎么样实现把数据表格帮在MyDorpDownList

dkjdkj 2007-03-15 03:35:58

<body>
<form id="form1" runat="server">
<div align="center">
<asp:Repeater ID="MyRepeater" runat="server">
<ItemTemplate>
<asp:DropDownList ID="MyDropDownList" runat="server"></asp:DropDownList>
</ItemTemplate>
</asp:Repeater>
</div>
</form>
</body>

public partial class Repeater : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
BindDropDownList();
}

public SqlConnection CreateConn()
{
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.AppSettings["SqlConnString"];
con.Open();
return con;
}

public void BindDropDownList()
{
SqlConnection conn = CreateConn();
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand("select * from a_cat where sid<>0",conn);
DataSet ds = new DataSet();
adapter.Fill(ds, "a_cat");
MyRepeater.DataSource = ds.Tables["a_cat"].DefaultView;
MyRepeater.DataBind();
}
}
问问，怎么样实现把表格a_cat 绑定在MyDorpDownList 上，当然Repeater上也要显示其他表的内容。

...全文

154 8 打赏收藏转发到动态举报

写回复

用AI写文章

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

nunucool 2007-03-15

打赏
举报

dkjdkj 2007-03-15

打赏
举报

public partial class Repeater : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
BindDropDownList();
}

public SqlConnection CreateConn()
{
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.AppSettings["SqlConnString"];
con.Open();
return con;
}

public void BindDropDownList()
{
SqlConnection conn = CreateConn();
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand("select * from a_cat where sid<>0", conn);
DataSet ds = new DataSet();
adapter.Fill(ds, "a_cat");
MyRepeater.DataSource = ds.Tables["a_cat"].DefaultView;
MyRepeater.DataBind();
}

protected void MyRepeater_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
SqlConnection conn = CreateConn();
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand("select * from a_cat where sid<>0", conn);
DataSet ds = new DataSet();
adapter.Fill(ds, "a_cat");

DropDownList MyDropDownList = (DropDownList)e.Item.FindControl("MyDropDownList");
MyDropDownList.DataSource = ds.Tables["a_cat"].DefaultView;
MyDropDownList.DataTextField = "cat_name";
MyDropDownList.DataValueField = "cat_id";
MyDropDownList.DataBind();
}
}

可以帮数据调到DropDownList里面了，但是也面上数据库表里有多少个数据，也面上也有就几个DropDownList

xray2005 2007-03-15

打赏
举报

在Repeater的ＩtemＤataＢound事件中写
DropDownList dlist=e.Items.FindControls("MyDropDownList") as DropDownList
if(dlist!=null)
{
string sql = "";
DataSet ds = DbHelperSQL.Query(sql);
this.MyDropDownList.DataTextField = "DirNameChs";
this.MyDropDownList.DataValueField = "DirectoryID";
this.MyDropDownList.DataSource = ds;
this.MyDropDownList.DataBind();
}

dkjdkj 2007-03-15

打赏
举报

DropDownList 是在Repeater 中的，所以在绑定的时候是找不到this.MyDropDownList的

hy_lihuan 2007-03-15

打赏
举报

(DropDownList)e.Items.FindControls("MyDropDownList")
在DataBound事件里面写

hy_lihuan 2007-03-15

打赏
举报

string sql = "";
DataSet ds = DbHelperSQL.Query(sql);
this.MyDropDownList.DataTextField = "DirNameChs";
this.MyDropDownList.DataValueField = "DirectoryID";
this.MyDropDownList.DataSource = ds;
this.MyDropDownList.DataBind();
只能绑定两个字段阿，一个作为Text，一个作为Value；
不能把其他更多的字段绑定上ddl了

dkjdkj 2007-03-15