asp.net ObjectDataSource example: how to populate BulletedList
BulletedListObjectDataSourceExample.aspx
<%@ Page Language="C#" %>
<!DOCTYPE html>
<script runat="server">
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>asp.net ObjectDataSource example: how to populate BulletedList</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<h2 style="color:Navy">BulletedList ObjectDataSource Example</h2>
<asp:ObjectDataSource
ID="ObjectDataSource1"
runat="server"
TypeName="ProductList"
SelectMethod="GetProducts"
>
</asp:ObjectDataSource>
<asp:BulletedList
ID="BulletedList1"
runat="server"
DataSourceID="ObjectDataSource1"
DataTextField="ProductName"
DataValueField="ProductID"
BackColor="OrangeRed"
BorderColor="Crimson"
BorderWidth="2"
ForeColor="AliceBlue"
Font-Italic="true"
Width="300"
BulletStyle="LowerRoman"
>
</asp:BulletedList>
</div>
</form>
</body>
</html>
ProductList.cs
using System.Data;
using System.Data.SqlClient;
using System.Web.Configuration;
/// <summary>
/// Summary description for ProductList
/// </summary>
public class ProductList
{
public ProductList(){}
public DataSet GetProducts()
{
SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString = WebConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString;
SqlCommand myCommand = new SqlCommand();
myCommand.CommandText = "SELECT TOP 15 ProductID, ProductName From Products";
myCommand.Connection = myConnection;
SqlDataAdapter myAdapter = new SqlDataAdapter(myCommand);
DataSet productsDataSet = new DataSet();
myAdapter.Fill(productsDataSet);
return productsDataSet;
}
}
