填充一个下拉列表中使用SQL [英] Populate a Dropdown list With SQL

问题描述

我有一个DropDownList在我的asp.net网站，但我不能让它从我的SQL Server数据填充。

我这么想吗？

 暗淡sqlconn作为新的SqlConnection
昏暗sqCmd作为新的SqlCommand
昏暗作为SQLReader的SqlDataReader对象sqlconn.ConnectionString =服务器= .......;数据库= ......;用户ID = ....
密码= ....sqCmd.Connection = sqlconn
sqlconn.Open（）
sqCmd.CommandText =SELECT DISTINCT CompanyDivision从报告中
= SQLReader的sqCmd.ExecuteReader（）DropDownList.DataSource = SQLReader的
DropDownList.DataTextField =CompanyDivision
DropDownList.DataValueField =CompanyDivision
DropDownList.DataBind（）sqlreader.Close（）
sqlconn.Close（）
 

解决方案

SQL查询连接到一个下拉的最直接的方法是通过使用的的SqlDataSource 中在ASPX。

您可以做到这一点是这样的：

 ＆LT; ASP：SqlDataSource的=服务器
                             ID =CompanyDivisionSource
                             DataSourceMode =DataReader的
                             的ConnectionString =下;％$的ConnectionStrings：YourConnectionStringKey％＆gt;中
                             的SelectCommand =SELECT DISTINCT CompanyDivision从报告中
＆LT; ASP：DropDownList的=服务器
                             的DataSourceID =CompanyDivisionSource
                             DataTextField =CompanyDivision
                             DataValueField =CompanyDivision/＆GT;
 

我推荐的连接字符串也使用了前pression的。你需要放置在web.config文件中的连接字符串时，℃在;是connectionStrings＆GT; 标记。您将它们能够重复使用跨多个页面相同的连接，而无需硬code将其在每次使用。

更多关于的SqlDataSource 可以的这个概述。

i have a DropDownList in my asp.net website but i can not get it to populate with data from my sql server.

am i missing something?

Dim sqlconn As New SqlConnection  
Dim sqCmd As New SqlCommand       
Dim sqlreader As SqlDataReader    

sqlconn.ConnectionString = "server = .......;Database=......;User ID=....
Password=...." 

sqCmd.Connection = sqlconn
sqlconn.Open()
sqCmd.CommandText = "SELECT DISTINCT CompanyDivision FROM Reports"
sqlreader = sqCmd.ExecuteReader()

DropDownList.DataSource = sqlreader
DropDownList.DataTextField = "CompanyDivision"
DropDownList.DataValueField = "CompanyDivision"
DropDownList.DataBind()

sqlreader.Close()
sqlconn.Close()

解决方案

The most straightforward way of attaching a sql query to a dropdown is through the use of a SqlDataSource in the aspx.

You can do it like this:

<asp:SqlDataSource runat="server" 
                             ID="CompanyDivisionSource"
                             DataSourceMode="DataReader"
                             ConnectionString="<%$ ConnectionStrings:YourConnectionStringKey%>"
                             SelectCommand="SELECT DISTINCT CompanyDivision FROM Reports"
<asp:DropDownList runat="server" 
                             DataSourceID="CompanyDivisionSource" 
                             DataTextField = "CompanyDivision"
                             DataValueField = "CompanyDivision" />

I recommend the use of that expression for the connection string also. You need to place your connection string on the web.config file, under the <connectionStrings> tag. You will them be able to reuse the same connection across many pages without having to hardcode it on every use.

More about the SqlDataSource can be found on this overview.

这篇关于填充一个下拉列表中使用SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！