如何样实现把数据表格帮在MyDorpDownList
日期：2014-05-19 浏览次数：20432 次
怎么样实现把数据表格帮在MyDorpDownList
<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上也要显示其他表的内容。
------解决方案--------------------
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了
------解决方案--------------------
在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 ";
<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上也要显示其他表的内容。
------解决方案--------------------
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了
------解决方案--------------------
在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 ";
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
