AccessDataSource Constructor (String, String)
.NET Framework (current version)
Initializes a new instance of the AccessDataSource class with the specified data file path and Select command.
Assembly: System.Web (in System.Web.dll)
Parameters
- dataFile
-
Type:
System.String
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
-
Type:
System.String
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.
| Exception | Condition |
|---|---|
| ArgumentNullException | dataFile is null or an empty string. |
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="C#" %> <!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, 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 Page.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.DataSource = accessDS; // Explicitly call DataBind CheckBoxList1.DataBind(); } </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>
.NET Framework
Available since 2.0
Available since 2.0
Show: