Hi folks,
I need to have two ddl's in one DataGrid cell. The first ddl has a list of
company names and the second has a list of contact names that work in the
company name that was selected in the first ddl.
Any replies will be greatly appreciate.
Here are 3 functions / subroutines that do the following:
1) GetCompanyNames ForThisProject
2) GetContactsFrom CompanyForThisP roject
3) ddlTo_SelectedI ndexChanged
Function GetCompanyNames ForThisProject( ) as DataSet
dsCompanyNames. Clear()
Dim strConnString As String = "Provider=Micro soft.Jet.OLEDB. 4.0;
Ole DB Services=-4; Data
Source=c:\sites \single29\gmead ows73\database\ fdmdb.mdb"
Dim queryString As String = "SELECT DISTINCT [users].[cname] FROM
[users] WHERE ([users].[project] = '" & Session("projec t") & "')"
Dim dataAdapter As New OleDbDataAdapte r (querystring, strConnString)
dataAdapter.Fil l(dsCompanyName s, "users
Return dsCompanyNames
End Function
Function GetContactsFrom CompanyForThisP roject () As DataSet
' dsContacts.Clea r()
Dim strConnString As String =
"Provider=Micro soft.Jet.OLEDB. 4.0; Ole DB Services=-4; Data
Source=C:\sites \single29\gmead ows73\database\ fdmdb.mdb"
Dim queryString As String
queryString = "SELECT [users].[name] FROM [users] WHERE
(([users].[cname] = '" & coName & "') AND ([users].[project] = '" &
Session("projec t") & "'))"
Dim dataAdapter As New OleDbDataAdapte r (queryString,
strConnString)
dataAdapter.Fil l(dsContacts, "users")
Return dsContacts
End Function
Sub ddlTo_SelectedI ndexChanged(sen der As Object, e As EventArgs)
Dim list As DropDownList = CType(sender, DropDownList)
coName = list.SelectedIt em.Text
Dim ddlContact As DropDownList = CType(sender, DropDownList)
ddlContact.Data Source = GetContactsFrom CompanyForThisP roject ()
ddlContact.Data Bind ( )
End Sub
The first ddl is populated with company names. When it is selected the code
travels into the second function to get the contact names for the company
that was selected. The problem is that the second ddl is never populated
with the contact names.
My DataGrid html snippet is as follows:
<asp:TemplateCo lumn HeaderText="To"
SortExpression= "questionto ">
<ItemTemplate >
<%# DataBinder.Eval (Container.Data Item,
"questionto ") %>
</ItemTemplate>
<EditItemTempla te>
<asp:Label id="lblFrom" text="Company: "
runat="server" />
<br />
<asp:DropDownLi st id="ddlTo" runat="server"
DataValueField= "cname" AutoPostBack="T rue" DataSource='<%#
GetCompanyNames ForThisProject( ) %>'
OnSelectedIndex Changed="ddlTo_ SelectedIndexCh anged" />
<asp:Label id="lblContact " text="Contact: "
runat="server" />
<br />
<asp:DropDownLi st id="ddlContact " runat="server"
DataValueField= "name" AutoPostBack="T rue" DataSource='<%#
GetContactsFrom CompanyForThisP roject() %>'/>
</EditItemTemplat e>
</asp:TemplateCol umn>
