Adding information to a dropdownlist from a dataset

  • Thread starter Thread starter Lennie
  • Start date Start date
L

Lennie

Hello.


i have tree dropdownlist that i want to add some information from a databas.
The sql questions is like this for the tree dropdownlist´s

SELECT distinct eventuser
FROM syslog..tblsecurityEvents
where eventuser like 'PHONERA%' and eventuser not like '%$'

SELECT distinct eventuser
FROM syslog..tblsecurityEvents
where eventuser like 'PHONERA%' and eventuser like '%$'

SELECT distinct eventuser
FROM syslog..tblsecurityEvents
where eventuser not like 'PHONERA%'

but.. I don't want to make 3 dataset.
Can I just do one dataset like this.

SELECT distinct eventuser
FROM syslog..tblsecurityEvents

And the use some type off dataview or something else to sort the information
on the right dropdownlist.
The code I am using right now is something like

Dim show_users As SqlDataAdapter = New SqlDataAdapter("SELECT distinct
eventuser FROM syslog..tblsecurityEvents where eventuser like 'PHONERA%' and
eventuser not like '%$'", connect1)

show_users.Fill(PortalData, "eventuser")

DropDownList1.DataSource = PortalData
DropDownList1.DataMember = ("eventuser")
DropDownList1.DataTextField = ("eventuser")
DropDownList1.DataBind()

// Lennie
Phonera.se
 
Hi Lennie,

Yes, you could use DataView.
Just create a DataView (for each dropdown) with filter and use it as a
datasource.
 
Hi Lennie,

Something like:
Dim dv as DataView = new DataView(ds.Tables("eventuser"), "Colum1 = 1 AND
Column2 LIKE 'AAA%'", "Column1 ASC", DataViewRowState.CurrentRows)

DropDownList1.DataSource = dv
// no datamemeber
 
Back
Top