When you are programming web pages it is very important to optimize your code for better and faster performance. In this part I will show you how to optimize code for filling multiple dropdownlists with data from Microsoft Access. The same thing is with SQL Server. I'm using asp.net 2.0 and Microsoft Visual Studio 2005.

Add new Module to your project and name it DataOperations (Right Click Project - Add New Item - Class. Change class to module, like this:

Public Module DataOperations

End Module

Now write code for filling dropdownlist:

Imports System.Data.OleDb
Imports System.Configuration.ConfigurationManager

Public Module DataOperations

    Public Sub FillDropDown(ByVal ddl As DropDownList, ByVal tbl As String, ByVal txt As String, ByVal val As String)
        Dim cn As New OleDbConnection(ConnectionStrings("Data").ConnectionString.ToString)
        Dim cmd As New OleDbCommand
        cmd.CommandType = Data.CommandType.Text
        cmd.Connection = cn
        cmd.CommandText = "SELECT " & val & ", " & txt & " FROM " & tbl & " ORDER BY " & txt & " ASC"
        Dim dr As OleDbDataReader
        dr = cmd.ExecuteReader(Data.CommandBehavior.CloseConnection)
        While dr.Read
            ddl.Items.Add(New ListItem(dr(txt).ToString.Trim, dr(val)))
        End While
    End Sub

End Module

Now all you need to do to fill dropdownlist is to call this sub like:

FillDropDown(Me.cmbCategory, "Categories", "Category", "ID")

You need to pass parameters: dropdown name, table or query for fill, table column for text and table column for value.
If you need you can expand this sub by adding where and order by parameters.

Hope this helps.

Votes + Comments
v.good :fa3hed
10 Years
Discussion Span
Last Post by Mariandi

i'm sorry, i'm new here. i just wanna ask two question...we can develop vb.net as online system?it is because i have one project that i wanna develop. online system using vb.net.i just want a confirmation about this.....

2) if i can develop vb.net online system, can i send message from system to mobile ( like sms system )

tq...plzzz :' (help and give ur opinion...thanks:)


2)yes you can send messages from system to mobile using a GSM device and creating the appropriate functions to use the GSM device.

1) i don't think that is possible, you should try asp.net which i hear is not that different from vb.net( although it is hearsay)

Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.