Hi,
I have two drop down lists boxes, upon page load first DDL gets populated and depending on user's selection on first DDL second DDL (child DDL) gets populated, works fine. My problem is when user goes back and makes another selection on first (parent) DDL (note that it's not a postback event, since user did not leave the page yet!! OR is that right? I am bit confused about the IsPostBack property),
So when selection in first DDL changes, it should automatically clear the Child DDL (which is still showing values for the first selection, which is deceiving)
When user actually clicks on a button to populate the Child DDL, it shows correct values for the new selection.
But when I use SelectedIndexChanged even on first DDL to clear Child DDL, it never gets triggered
This is my code
Any help is highly appreciated
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here
If Not IsPostBack() Then
'Session("Current_Release_Id") = 1
Dim MySQLString As String
Dim objParam1 As SqlParameter
Dim MyReader As SqlDataReader
Dim MyConn As SqlConnection
Dim Mycmd As SqlCommand
Dim MyDataAdapter As SqlDataAdapter
Dim cnt As Integer
Dim str As String
Dim MyDataSet As New DataSet
Try
MyConn = New SqlConnection(ConfigurationSettings.AppSettings("Conn"))
MySQLString = "Select DISTINCT PackageName , PackageId "
MySQLString = MySQLString + " FROM Package "
MySQLString = MySQLString + "WHERE (Package.ReleaseId = @PackageRelId) ORDER BY PackageName"
MyDataAdapter = New SqlDataAdapter(MySQLString, MyConn)
objParam1 = MyDataAdapter.SelectCommand.Parameters.Add("@PackageRelId", SqlDbType.Int)
objParam1.Value = Rel_Matrix_Id.Text.Trim
str = Rel_Matrix_Id.Text.Trim
PackageNameDDL.Items.Clear()
If MyConn.State = ConnectionState.Closed Then
MyConn.Open()
End If
cnt = MyDataAdapter.Fill(MyDataSet)
If cnt = 0 Then
ComponentDDL.Visible = False
CompBtn.Visible = False
Say("No Packages are Added to this Release!!")
Exit Try
End If
ComponentDDL.Visible = True
CompBtn.Visible = True
'MyDataAdapter.Dispose()
PackageNameDDL.DataSource = MyDataSet
PackageNameDDL.DataTextField = "PackageName"
PackageNameDDL.DataValueField = "PackageId"
PackageNameDDL.DataBind()
MyConn.Dispose()
MyConn.Close()
Catch ex As Exception
Say("[PageLoad] Exception " & ex.Message)
System.Diagnostics.Trace.WriteLine("[ShowBtnClick] Exception " & ex.Message)
Finally
MyConn.Close()
End Try
End If
End SubFirst DDL is populated and now after click of a button second DDL gets populated
Private Sub CompBtn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CompBtn.Click
Dim MySQLString As String
Dim objParam1 As SqlParameter
Dim MyReader As SqlDataReader
Dim MyConn As SqlConnection
Dim Mycmd As SqlCommand
Dim MyDataAdapter As SqlDataAdapter
Dim cnt As Integer
Dim str As String
Dim MyDataSet As New DataSet
Try
MyConn = New SqlConnection(ConfigurationSettings.AppSettings("Conn"))
MySQLString = "Select DISTINCT ComponentID , Description "
MySQLString += " FROM Component"
MySQLString += " WHERE (PackageID = @PackageId) ORDER BY Description"
MyDataAdapter = New SqlDataAdapter(MySQLString, MyConn)
objParam1 = MyDataAdapter.SelectCommand.Parameters.Add("@PackageId", SqlDbType.Int)
objParam1.Value = PackageNameDDL.SelectedItem.Value.Trim
ComponentDDL.Items.Clear()
If MyConn.State = ConnectionState.Closed Then
MyConn.Open()
End If
cnt = MyDataAdapter.Fill(MyDataSet)
If cnt = 0 Then
Say("No Components are Added to this Package!!")
Exit Try
End If
'MyDataAdapter.Dispose()
ComponentDDL.DataSource = MyDataSet
ComponentDDL.DataTextField = "Description"
ComponentDDL.DataValueField = "ComponentID"
ComponentDDL.DataBind()
MyConn.Dispose()
MyConn.Close()
Catch ex As Exception
Say("[ShowComponent BtnClick] Exception " & ex.Message)
System.Diagnostics.Trace.WriteLine("[ShowComponent BtnClick] Exception " & ex.Message)
Finally
MyConn.Close()
End Try
End Subworks great... but what if user wants to change the package (first DDL) selection, my child DDL still shows old values until user clicks on the button again.. I tried to do something like this
Private Sub PackageNameDDL_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PackageNameDDL.SelectedIndexChanged
ComponentDDL.Items.Clear()
End Subbut the event never triggers, what am I doing wrong ?
:sad: :cry: :confused: