newbie question

Troy · Nov 11, 2003

Hello,

I'm learning asp.net so please excuse the question: I;d list to populate the
listbox control with data from sql and I have no idea on how to do it.
Below is my code that displays it in a datagrid.

TIA

<%@ import namespace="System.Data" %>
<%@ import namespace="System.Data.sqlclient" %>
<%@ Page Language="vb" Debug="true" %>

<script language="vb" runat="server">
'Place the following in a server side script in your aspx or in the
codebehind:
Sub Page_Load(Sender As Object, E As EventArgs)
Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter
MyConnection = new
sqlConnection("server=ServerA;uid=app;pwd=password;database=northwind")
MyCommand = New SqlDataAdapter("select CompanyName from Customers",
MyConnection)
DS = new DataSet()
MyCommand.Fill(ds, "Customers")
MyDataGrid.DataSource=ds.Tables("Customers").DefaultView
MyDataGrid.DataBind()
End Sub

</script>

<html>
<body>
<form runat="server">
<asp

ataGrid id="MyDataGrid" runat="Server" font-size="10" />
</form>
</body>

S Gopikrishna · Nov 11, 2003

The following source code may be helpful to you

<%@ Page Language="VB" EnableSessionState="False"
EnableViewState="False" debug="False" trace="False"
strict="True" %>
<%@ Import Namespace="System.Data.SQLClient" %>
<script language=VB runat=server>

Sub Page_Load(Sender As Object, E As EventArgs)
Dim myConnection As SqlConnection = New SqlConnection
(ConfigurationSettings.AppSettings("DSN_pubs"))
Dim mySQL as string = "Select au_id, au_lname, au_fname
from Authors"
Dim myCmd as New SQLCommand(mySQL,myConnection)
myConnection.Open()

MyDropDownList.DataSource = myCmd.ExecuteReader()
myDropDownList.DataBind()
myConnection.Close()
End Sub

</script>
<html>
<head><title>DropListBox using
SQLDataReader</title></head>

<body>
<asp:dropdownlist id="MyDropDownList" DataValueField
= "au_lname" DataTextField = "au_id" runat="server"/>
</body>
</html>

-Gopi

Troy · Nov 11, 2003

Thanks - I really appreciate it.

S Gopikrishna said:
The following source code may be helpful to you

<%@ Page Language="VB" EnableSessionState="False"
EnableViewState="False" debug="False" trace="False"
strict="True" %>
<%@ Import Namespace="System.Data.SQLClient" %>
<script language=VB runat=server>

Sub Page_Load(Sender As Object, E As EventArgs)
Dim myConnection As SqlConnection = New SqlConnection
(ConfigurationSettings.AppSettings("DSN_pubs"))
Dim mySQL as string = "Select au_id, au_lname, au_fname
from Authors"
Dim myCmd as New SQLCommand(mySQL,myConnection)
myConnection.Open()

MyDropDownList.DataSource = myCmd.ExecuteReader()
myDropDownList.DataBind()
myConnection.Close()
End Sub

</script>
<html>
<head><title>DropListBox using
SQLDataReader</title></head>

<body>
<asp:dropdownlist id="MyDropDownList" DataValueField
= "au_lname" DataTextField = "au_id" runat="server"/>
</body>
</html>

-Gopi

Newbie Question	5	Apr 7, 2006
ASP.net: Error "Exception Details: System.InvalidOperationException: The ConnectionString property h	6	Jun 15, 2004
Newbie VB.net ASPX question	0	May 2, 2007
Param dataGrid Question	2	Dec 23, 2004
param datagrid question	0	Dec 23, 2004
Newbie: Datagrid is Completely Blank?!?	2	May 1, 2005
InProc vs StateServer	6	Jul 16, 2005
Newbie Alert: Please help with repeater control and list box	1	Mar 2, 2004

newbie question

Troy

S Gopikrishna

Troy

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads