Dropdown list issues

  • Thread starter Thread starter Fendi Baba
  • Start date Start date
F

Fendi Baba

I faced 2 isseues. First, I created three (3) dropdown list on my
page. They are populated by an event triggered in the page load
command.

What's strange is that the frist drop downlist gets populated as
expected but the second and third do not get populated at all. I dont
think I made any mistake but can anyone verfiy if I made an error
somewhere?

here is my onload code:

Imports System.Data.SqlClient
Imports System.Web.Configuration
Partial Class supervisor_keyword
Inherits System.Web.UI.Page
Dim strconnectionString As String =
WebConfigurationManager.ConnectionStrings("LocalSqlServer").ConnectionString
Dim con As New SqlConnection(strconnectionString)
Dim cmd As New SqlCommand("", con)
Dim recordcount As String
Protected Sub Page_Load(ByVal sender As Object, ByVal e As
System.EventArgs) Handles Me.Load
Dim myda As SqlDataAdapter
Dim ds As Data.DataSet
myda = New SqlDataAdapter("SELECT * from gown_AdminStocks",
strconnectionString)
ds = New Data.DataSet
myda.Fill(ds, "AllTables")
GridViewStocks.DataSource = ds
GridViewStocks.DataSource = ds.Tables(0)

GridViewStocks.DataBind()
DropDownListSize.DataSource = ds
DropDownListSize.DataSource = ds.Tables(0)

DropDownListSize.DataTextField =
ds.Tables(0).Columns("SizeID").ColumnName.ToString()
DropDownListSize.DataValueField =
ds.Tables(0).Columns("SizeID").ColumnName.ToString()
DropDownListSize.DataBind()

Dim mydaprice As SqlDataAdapter
Dim dsprice As Data.DataSet
mydaprice = New SqlDataAdapter("SELECT * from
gown_AdminCost", strconnectionString)
dsprice = New Data.DataSet
mydaprice.Fill(dsprice, "CostTables")
GridViewPriceGrid.DataSource = dsprice
GridViewPriceGrid.DataSource = dsprice.Tables(0)
GridViewPriceGrid.DataBind()


DropDownPriceGrid.DataTextField =
dsprice.Tables(0).Columns("CostType").ColumnName.ToString()
DropDownPriceGrid.DataValueField =
dsprice.Tables(0).Columns("CostID").ColumnName.ToString()
DropDownPriceGrid.DataBind()


Dim mydakey As SqlDataAdapter
Dim dskey As Data.DataSet
mydakey = New SqlDataAdapter("SELECT * from
gown_AdminKeyword", strconnectionString)
dskey = New Data.DataSet
mydakey.Fill(dskey, "KeywordTables")
GridViewKeywords.DataSource = dskey
GridViewKeywords.DataSource = dskey.Tables("KeywordTables")
GridViewKeywords.DataBind()


DropDownListKeyword.DataTextField =
dskey.Tables(0).Columns("Keyword").ColumnName.ToString()
DropDownListKeyword.DataValueField =
dskey.Tables(0).Columns("KeywordID").ColumnName.ToString()
DropDownListKeyword.DataBind()



End Sub
End Class

Secondly, when I select the items in the first dropdownlist, It only
returns the value of the first item, irregardless of what has been
selected. This is strnage as I have done this something similar but
never run into this issues. Any thought?

Thanks in advance.
 
1.You don't seem to set datasource for the second and third ddl.

2.You always reload the first ddl on every postback. Databind it only if
IsPostBack is false.

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]http://msmvps.com/blogs/egoldinhttp://usableasp.net




I faced 2 isseues. First, I created three (3) dropdown list on my
page. They are populated by an event triggered in the page load
command.
Click to expand...
What's strange is that the frist drop downlist gets populated as
expected but the second and third do not get populated at all. I dont
think I made any mistake but can anyone verfiy if I made an error
somewhere?
Click to expand...
here is my onload code:
Click to expand...
Imports System.Data.SqlClient
Imports System.Web.Configuration
Partial Class supervisor_keyword
Inherits System.Web.UI.Page
Dim strconnectionString As String =
WebConfigurationManager.ConnectionStrings("LocalSqlServer").ConnectionStrin­g
Dim con As New SqlConnection(strconnectionString)
Dim cmd As New SqlCommand("", con)
Dim recordcount As String
Protected Sub Page_Load(ByVal sender As Object, ByVal e As
System.EventArgs) Handles Me.Load
Dim myda As SqlDataAdapter
Dim ds As Data.DataSet
myda = New SqlDataAdapter("SELECT * from gown_AdminStocks",
strconnectionString)
ds = New Data.DataSet
myda.Fill(ds, "AllTables")
GridViewStocks.DataSource = ds
GridViewStocks.DataSource = ds.Tables(0)
Click to expand...
GridViewStocks.DataBind()
DropDownListSize.DataSource = ds
DropDownListSize.DataSource = ds.Tables(0)
Click to expand...
DropDownListSize.DataTextField =
ds.Tables(0).Columns("SizeID").ColumnName.ToString()
DropDownListSize.DataValueField =
ds.Tables(0).Columns("SizeID").ColumnName.ToString()
DropDownListSize.DataBind()
Click to expand...
Dim mydaprice As SqlDataAdapter
Dim dsprice As Data.DataSet
mydaprice = New SqlDataAdapter("SELECT * from
gown_AdminCost", strconnectionString)
dsprice = New Data.DataSet
mydaprice.Fill(dsprice, "CostTables")
GridViewPriceGrid.DataSource = dsprice
GridViewPriceGrid.DataSource = dsprice.Tables(0)
GridViewPriceGrid.DataBind()
Click to expand...
DropDownPriceGrid.DataTextField =
dsprice.Tables(0).Columns("CostType").ColumnName.ToString()
DropDownPriceGrid.DataValueField =
dsprice.Tables(0).Columns("CostID").ColumnName.ToString()
DropDownPriceGrid.DataBind()
Click to expand...
Dim mydakey As SqlDataAdapter
Dim dskey As Data.DataSet
mydakey = New SqlDataAdapter("SELECT * from
gown_AdminKeyword", strconnectionString)
dskey = New Data.DataSet
mydakey.Fill(dskey, "KeywordTables")
GridViewKeywords.DataSource = dskey
GridViewKeywords.DataSource = dskey.Tables("KeywordTables")
GridViewKeywords.DataBind()
Click to expand...
DropDownListKeyword.DataTextField =
dskey.Tables(0).Columns("Keyword").ColumnName.ToString()
DropDownListKeyword.DataValueField =
dskey.Tables(0).Columns("KeywordID").ColumnName.ToString()
DropDownListKeyword.DataBind()
Click to expand...
End Sub
End Class
Click to expand...
Secondly, when I select the items in the first dropdownlist, It only
returns the value of the first item, irregardless of what has been
selected. This is strnage as I have done this something similar but
never run into this issues. Any thought?
Click to expand...
Thanks in advance.- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...
Elliyahu

1. In both the second and third ddl, i set these respectively:

Dim mydaprice As SqlDataAdapter
Click to expand...

DropDownPriceGrid.DataBind()



and


Dim mydakey As SqlDataAdapter
DropDownListKeyword.DataBind()
Click to expand...


Is this done wrongly?

Thanks gfor your input. I think the Ispost back issue might be the
cause of the second problem.
 
Elliyahu

1. In both the second and third ddl, i set these respectively:


DropDownPriceGrid.DataBind()

and

Dim mydakey As SqlDataAdapter

DropDownListKeyword.DataBind()



Is this done wrongly?

Thanks gfor your input. I think the Ispost back issue might be the
cause of the second problem.- Hide quoted text -

- Show quoted text -
Click to expand...

Elliyahu

I saw the problem with the datasource. Thanks for pointing it out.

Regards
 
Back
Top