AccessDataSource.AccessDataSource(String, String) Constructor
.NET Framework 3.0
Initializes a new instance of the AccessDataSource class with the specified data file path and Select command.
Namespace: System.Web.UI.WebControls
Assembly: System.Web (in system.web.dll)
Assembly: System.Web (in system.web.dll)
public AccessDataSource ( String dataFile, String selectCommand )
public function AccessDataSource ( dataFile : String, selectCommand : String )
Not applicable.
Parameters
- dataFile
The location of the Access .mdb file. The location can be relative to the current Web form's folder, an absolute physical path, or a virtual path.
- selectCommand
The SQL query used to retrieve data from the Access database. If the SQL query is a parameterized SQL string, add Parameter objects to the SelectParameters collection.
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 AccessDataSource
AccessDataSource accessDS = new AccessDataSource(
"~/App_Data/Northwind.mdb","SELECT SupplierID, CompanyName "
+" FROM Suppliers WHERE Country ='Germany'");
// Add the AccessDataSource to the Page.Controls collection
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: