AccessDataSource.AccessDataSource() Constructor
.NET Framework 3.0
Initializes a new instance of the AccessDataSource class.
Namespace: System.Web.UI.WebControls
Assembly: System.Web (in system.web.dll)
Assembly: System.Web (in system.web.dll)
The following code example demonstrates how to use the AccessDataSource constructor to create a new AccessDataSource data source control and bind a CheckBoxList control to data in a Microsoft Access database.
<%@ Page Language="VJ#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
private void Page_Load(Object sender, System.EventArgs e)
{
// Create the AccessDataSource.
AccessDataSource accessDS = new AccessDataSource();
accessDS.set_SelectCommand ("SELECT SupplierID, CompanyName "
+ "FROM Suppliers WHERE Country ='Germany'");
accessDS.set_DataFile ( "~/App_Data/Northwind.mdb");
// Add the AccessDataSource to the Page.Controls
// collection.AccessDataSourceAccessDataSourceAccessDataSource
get_Page().get_Controls().Add(accessDS);
// In programmatic scenarios, use the DataSource
// property, not the DataSourceID property. The Select method
// returns an IEnumerable list of data items.
CheckBoxList1.set_DataSource(accessDS);
// Explicitly call DataBind.
CheckBoxList1.DataBind();
}//Page_Load
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>ASP.NET Example</title>
</head>
<body>
<form id="form1" runat="server">
<asp:CheckBoxList
id="CheckBoxList1"
runat="server"
DataTextField="CompanyName"
DataValueField="SupplierID">
</asp:CheckBoxList>
</form>
</body>
</html>
Community Additions
ADD
Show: