Asp.Net Programming Asp.Net > Code Snippets Code Examples Do not forget to modify database connection and your sql statement. Do not forget to modify database connection and your sql statement. <%@ Page Language="VB" Debug="true" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OLEDB" %> <script language="VB" runat="server"> Sub Page_Load(Source as Object, E as EventArgs) Dim objCon As OleDBConnection objCon = New OleDBConnection("Provider=sqloledb;Data Source=LOCALHOST;Initial catalog=northwind;User Id=sa;Password=;") Dim ds as new DataSet Dim objAdapter As OleDBDataAdapter = New OleDBDataAdapter("Select * from categories order by categoryID desc", objCon) objAdapter.Fill(ds) catList.DataSource=ds.tables(0).DefaultView catList.DataValueField="categoryID" catList.DataTextField="categoryName" catList.DataBind() end sub </script> <html><body> <form runat="server"> <asp:DropDownList id="catlist" runat="server"/> </form> </body></html>
