Tilføje et ikke Db hentet felt, i en dropdownlist?
Hej med jer,Hvordan tilføjer jeg et felt i min dropdownlist, som ikke bliver hentet fra Db?
Jeg vil bare tilføjge et felt hvor der står "vælg fra listen".
--------------------------------------------------------
Min drop down aspx kode:
<asp:DropDownList
id="DropDownList1"
AutoPostBack="True"
OnSelectedIndexChanged="subListChange"
runat="server"/>
----------------------------------------------------------
VB.NET Code-Behind kode:
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If Not IsPostBack Then
Dim newsTopic As News = New News()
DropDownList1.DataSource = newsTopic.GetNewsTopic()
DropDownList1.DataTextField = "Topic"
DropDownList1.DataValueField = "NewsID"
DropDownList1.DataBind()
End If
End Sub
-----------------------------------------------------------
I klasse filen som Code-Behind filen nedarver fra ligger Functionen som kalder SP'en:
Public Function GetNewsTopic() As SqlDataReader
Dim myConnection As New SqlConnection(connectionString)
Dim myCommand As New SqlCommand("GetSelectedNewsTopic", myConnection)
myCommand.CommandType = CommandType.StoredProcedure
myConnection.Open()
Dim result As SqlDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)
Return result
End Function
-----------------------------------------------------------
Min T-SQL ligger i en SP som ser sådan her ud:
ALTER PROCEDURE GetSelectedNews
(
@NewsID int
)
AS
SELECT
News.NewsID, News.Topic, News.SubTopic, News.News, News.NewsDate, News.Publisher
FROM
News
WHERE
News.NewsID = @NewsID
Håber at fra jer :-)
Mvh
/B.G.
