DropDownList数据绑定得问题～～～

呆呆辉 2005-07-06 06:48:56

请问我怎么让DropDownList绑定到一个数据库上，让DropDownList下拉选项显示数据库中某列数据。
大侠给段代码！谢！

...全文

160 4 打赏收藏转发到动态举报

写回复

用AI写文章

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

renyu732 2005-07-06

打赏
举报

然后，你可以在.vb中定义DDL的DataTextField,DataValueField值的，如：
Me.DropDownList1.DataTextField = "Text"
Me.DropDownList1.DataValueField = "Value"

renyu732 2005-07-06

打赏
举报

关键语句：
If Not IsPostBack Then
'数据绑定到DDL
End If

否则由于回发而导致数据错误．

myview 2005-07-06

打赏
举报

这里假设采用NT用户登陆数据库:
否则把Trusted_Connection=yes改为uid=用户名;pwd=密码;
代码如下:

string sqlstring ="select name,age from table1 ";
SqlConnection MyConnection=new qlConnection("server=IP地址/实例名;database=数据库名称;Trusted_Connection=yes");
SqlCommand MyCommand = new SqlCommand(sqlstring, MyConnection);
MyConnection.Open();
SqlDataReader dr = MyCommand.ExecuteReader();
DropDownList4.DataSource = dr;
DropDownList4.DataTextField = "表中字段名称";
DropDownList4.DataBind();
MyConnection.Close();

祝你好运!

孟子E章 2005-07-06

打赏
举报

<%@ Page language="VB" Debug="false" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQLClient" %>
<script language="VB" runat="server">
Sub Page_Load(Source As Object, E As EventArgs)
if Not Page.IsPostBack Then
Dim oConn As SQLConnection
Dim oComm As SQLCommand
Dim oReader As SQLDataReader
Dim sSQL As String
Dim sConn As String

sSQL= "SELECT au_id, au_fname + ' ' + au_lname AS AuthorName "
sSQL+= "FROM Authors"
sConn= "server=(local);database=pubs;Trusted_Connection=yes"

oConn = New SQLConnection(sConn)
oConn.Open()

oComm = New SQLCommand(sSQL,oConn)
oReader = oComm.ExecuteReader()

oAuthors.DataSource = oReader
oAuthors.DataBind()
end if
End Sub

Sub Go_Click(Src As Object, E As EventArgs)
SelectedItem.Text = "You picked " & oAuthors.SelectedItem.Text & " (" & _
oAuthors.SelectedItem.Value & ")."
End Sub
</script>
<html>
<head>
<title>Populate A Drop-down List From A SQL Server Database</title>
</head>
<body>
<form runat="server">
Please select an author:
<asp:DropDownList ID="oAuthors" DataTextField="AuthorName"
DataValueField="au_id" Runat="server" />
<asp:Button ID="Go" Text="Go" OnClick="Go_Click" Runat="server" />
<br />
<br />
<asp:Label ID="SelectedItem" Runat="server" />
</form>
</body>
</html>