AccessDataSource Constructors
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Initializes a new instance of the AccessDataSource class.
Overloads
| AccessDataSource() |
Initializes a new instance of the AccessDataSource class. |
| AccessDataSource(String, String) |
Initializes a new instance of the AccessDataSource class with the specified data file path and Select command. |
AccessDataSource()
Initializes a new instance of the AccessDataSource class.
public:
AccessDataSource();public AccessDataSource ();Public Sub New ()Examples
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 the AccessDataSource.
AccessDataSource accessDS = new AccessDataSource();
accessDS.SelectCommand = "SELECT SupplierID, CompanyName " +
" FROM Suppliers WHERE Country ='Germany'";
accessDS.DataFile = "~/App_Data/Northwind.mdb";
// 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>
<%@ Page Language="VB" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
' Create the AccessDataSource.
Dim accessDS As New AccessDataSource()
accessDS.SelectCommand = "SELECT SupplierID, CompanyName " & _
" FROM Suppliers WHERE Country ='Germany'"
accessDS.DataFile = "~/App_Data/Northwind.mdb"
' 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()
End Sub '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>
See also
Applies to
AccessDataSource(String, String)
Initializes a new instance of the AccessDataSource class with the specified data file path and Select command.
public:
AccessDataSource(System::String ^ dataFile, System::String ^ selectCommand);public AccessDataSource (string dataFile, string selectCommand);new System.Web.UI.WebControls.AccessDataSource : string * string -> System.Web.UI.WebControls.AccessDataSourcePublic Sub New (dataFile As String, selectCommand As String)Parameters
- dataFile
- 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
- 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.
Exceptions
dataFile is null or an empty string.
Examples
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>
<%@ Page Language="VB" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
' Create AccessDataSource
Dim accessDS As 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()
End Sub '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>
