How to bind ListBox using SqlDataSource in ASP.NET

ListBox is a collection of string . If you want to bind ListBox to database using SqlDataSource then you can follow same step as a Gridview binding.

How to bind GridView using SqlDataSource in ASP.NET

After making connection string in web.config file your wizard asking about DataTextField and DataValue field.
Select DataText Field in SqlDataSource



<%@ Page Language="C#" %>

<!DOCTYPE html>

<script runat="server">

</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
 
        <asp:ListBox ID="ListBox1" runat="server" DataSourceID="SqlDataSource1" DataTextField="namet" DataValueField="Id"></asp:ListBox>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM [footerex]"></asp:SqlDataSource>
 
    </div>
    </form>
</body>
</html>

Output
How to bind ListBox using SqlDataSource  in ASP.NET

How to bind ListBox using SqlDataSource in ASP.NET How to bind ListBox using SqlDataSource  in ASP.NET Reviewed by Jacob Lefore on September 16, 2013 Rating: 5

No comments