如何读出DropDownList已经邦定的值？

zeroman20 2007-05-20 02:09:10

已经邦定，邦定的表里有2列值，如何在DropDownList读出？我这里写的不对吧？谁能给我个我查了半天了。。。用不用循环？谢谢大家乐
<asp:templatecolumn >
<edititemtemplate>
<asp:dropdownlist id = "txtsort" selectedindex='<%#container.dataitem("data_sort")-1%>' runat = "server">
<asp:listitem>1</asp:listitem>
<asp:listitem>2</asp:listitem>
<asp:listitem>3</asp:listitem>
<asp:listitem>4</asp:listitem>
<asp:listitem>5</asp:listitem>
<asp:listitem>6</asp:listitem>
<asp:listitem>7</asp:listitem>
</asp:dropdownlist>
</edititemtemplate>
</asp:templatecolumn>

...全文

217 14 打赏收藏转发到动态举报

写回复

用AI写文章

14 条回复

切换为时间正序

请发表友善的回复…

发表回复

zeroman20 2007-05-20

打赏
举报

谢谢大家~ 搞定拉

-过客- 2007-05-20

打赏
举报

看amandag(高歌)给的代码，已经很全面了

zeroman20 2007-05-20

打赏
举报

请问 DataTextField和DataValueField
在哪里指定？晕晕~
页面中这样写就行吧<asp:DropDownList id="aaa"runat="server"/>

-过客- 2007-05-20

打赏
举报

楼主没有指定DataTextField和DataValueField

amandag 2007-05-20

打赏
举报

sub binddata()
'连接数据库设置datagrid'
txtSql = "select * from data_srt"
dim adp as new sqldataadapter(txtSql,conn)
dim ds as new dataSet()
adp.fill(ds,"stdBase")
txtsort.datasource=ds.tables("stdbase").defaultview
txtsort.DataTextField = "你打算绑定的字段名"
txtsort.DataValueField = "一般这个字段是主键"
txtsort.databind()
end sub

amandag 2007-05-20

打赏
举报

call binddata()
====================

If Not IsPostBack Then
binddata()
End If

zeroman20 2007-05-20

打赏
举报

您好先谢谢你帮我解答问题我真的是出学不是很懂能再帮我看看么？我的源代码发给你
--------------------------------------------------------------------
<%@ Page Language="Vb"@%>
sub page_load(sender as Object,e as EventArgs)
strCon = ConfigurationSettings.AppSettings("strCon")
conn = new sqlconnection(strCon)
call binddata()
end sub
sub binddata()
'连接数据库设置datagrid'
txtSql = "select * from data_srt"
dim adp as new sqldataadapter(txtSql,conn)
dim ds as new dataSet()
adp.fill(ds,"stdBase")
txtsort.datasource=ds.tables("stdbase").defaultview
txtsort.databind()
end sub
</script>
<html><body>
<form runat = "server"><table border="0" >
<asp:DropDownList id="txtsort" contorltovalidate = "data_sort" runat="server"/>
<tr><td><asp:button id = "enter" text = "提交" onClick ="enter_Click" runat="server" /></td></tr>
</table></form></body></html>

-过客- 2007-05-20

打赏
举报

晕，原来你不知道怎么绑定，一个例子

SqlConnection cnn = new SqlConnection("server=CNN;database=foodshop;uid=sa;password=");
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("select id, food_id, food_name from food ", cnn);
DataSet ds = new DataSet();
da.Fill(ds, "myFood");
DataTable dt = ds.Tables["myFood"];

//绑定数据
ddl.DataSource = dt;
ddl.DataValueField = "food_id";
ddl.DataTextField = "food_name";
ddl.DataBind();