Example of ListBox Control in ASP.Net Using C#

Nilesh Jadav
9y
31.4k
0
1

Article

Initial Chamber

Step 1

Open your Visual Studio 2010 and create an Empty Website, provide a suitable name (ListBox_demo).

Step 2

In Solution Explorer you get your empty website, add a web form and SQL Database as in the following.

For Web Form:

ListBox_demo (Your Empty Website) then right-click then select Add New Item -> Web Form. Name it as -> ListBox_demo.aspx.

For SQL Server Database:

Accordion_demo (Your Empty Website) then right-click then select Add New Item -> SQL Server Database. (Add the database inside the App_Data_folder).

Database Chamber

Step 3

In Server Explorer, click on your database (Database.mdf) then select Tables -> Add New Table. Make the table like this:

Table -> tbl_data (Don't forget to set the ID as IS Identity -- True).

Design Chamber

Step 4

Open your ListBox_demo.aspx file from Solution Explorer and begin designing you're application. Here is the code:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:ListBox ID="ListBox2" runat="server" DataSourceID="SqlDataSource1"
DataTextField="name" DataValueField="name"></asp:ListBox>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [name] FROM [tbl_data]"></asp:SqlDataSource>
</div>
<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Click Here " />
<br />
<br />
<br />
<br />
<br />
<asp:ListBox ID="ListBox1" runat="server" Width="100px"
></asp:ListBox>
</form>
</body>
</html>

We will use the DataSource as a SQL Server database, we will not write any code for SQL Connection and by just calling the Datasource of the Listbox it will do our work.

Then press Next then Next. It will then ask you about your table, just select here tbl_data, see the following image.

In the last window of configuring the data source, you can test the query. Just press the “Test Query” and it will fetch all the names into your database.

Code Chamber

Finally open your ListBox_demo.aspx.cs file to write the code, for making the list box as we assume.