AccessDataSource.ConnectionString Property
.NET Framework 3.0
Gets the connection string that is used to connect to the Microsoft Access database.
Namespace: System.Web.UI.WebControls
Assembly: System.Web (in system.web.dll)
Assembly: System.Web (in system.web.dll)
public: virtual property String^ ConnectionString { String^ get () override; void set (String^ value) override; }
/** @property */ public String get_ConnectionString () /** @property */ public void set_ConnectionString (String value)
public override function get ConnectionString () : String public override function set ConnectionString (value : String)
Not applicable.
Property Value
The OLE DB connection string that the AccessDataSource control uses to connect to an Access database, through the System.Data.OleDb .NET data provider.The AccessDataSource control can be used only with the System.Data.OleDb .NET data provider, and the connection string that AccessDataSource uses is specific to this provider. Therefore, the AccessDataSource control exposes connection string settings, such as the DataFile property, as a property and constructs a connection string at run time using the values of the ConnectionString property, if set.
The following code example demonstrates how to display the ConnectionString property of the AccessDataSource control in an ASP.NET Web page.
<%@ 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)
{
Label1.set_Text(AccessDataSource1.get_ConnectionString());
}//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:AccessDataSource
id="AccessDataSource1"
runat="server"
DataFile="Northwind.mdb">
</asp:AccessDataSource>
<asp:Label
id="Label1"
runat="server">
</asp:Label>
</form>
</body>
</html>
Community Additions
ADD
Show: