Export (0) Print
Expand All

AccessDataSource.ConnectionString Property

Note: This property is new in the .NET Framework version 2.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)

public override string ConnectionString { get; set; }
/** @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)

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.

Exception typeCondition

InvalidOperationException

An attempt was made to set the ConnectionString property.

The AccessDataSource control can be used only with the System.Data.OleDb .NET data provider, and the connection string that the 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 a Web Forms page.

<%@ 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) {
  Label1.Text = AccessDataSource1.ConnectionString;
}
</SCRIPT>

<HTML>
  <BODY>
    <FORM runat="server">

      <asp:AccessDataSource
        id="AccessDataSource1"
        runat="server"
        DataFile="Northwind.mdb">
      </asp:AccessDataSource>

      <asp:Label
        id="Label1"
        runat="server">
      </asp:Label>

    </FORM>
  </BODY>
</HTML>

<%@ 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>
  <BODY>
    <FORM runat="server">

      <asp:AccessDataSource
        id="AccessDataSource1"
        runat="server"
        DataFile="Northwind.mdb">
      </asp:AccessDataSource>

      <asp:Label
        id="Label1"
        runat="server">
      </asp:Label>

    </FORM>
  </BODY>
</HTML>

Windows 98, Windows 2000 SP4, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.

.NET Framework

Supported in: 2.0

Community Additions

ADD
Show:
© 2014 Microsoft