S
Sam
I would like to know why no DropDownList id value ?
Coding
-------
sub page_load()
Dim con As New
SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))
Dim cmd As New SqlCommand()
cmd.CommandText = "Select gl_date,gl_date_value from gldate"
cmd.Connection = con
Try
con.Open()
Dim rd As SqlDataReader = cmd.ExecuteReader()
DropDownlist_Date.DataSource = rd
DropDownlist_Date.DataTextField = "gl_date"
DropDownlist_Date.DataValueField = "gl_date_value"
DropDownlist_Date.DataBind()
rd.Close()
Finally
con.Close()
End Try
End Sub
<asp
ropDownList id="DropDownlist_Date" runat="server"></asp
ropDownList>
Coding
-------
sub page_load()
Dim con As New
SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))
Dim cmd As New SqlCommand()
cmd.CommandText = "Select gl_date,gl_date_value from gldate"
cmd.Connection = con
Try
con.Open()
Dim rd As SqlDataReader = cmd.ExecuteReader()
DropDownlist_Date.DataSource = rd
DropDownlist_Date.DataTextField = "gl_date"
DropDownlist_Date.DataValueField = "gl_date_value"
DropDownlist_Date.DataBind()
rd.Close()
Finally
con.Close()
End Try
End Sub
<asp