AccessDataSource.ConnectionString Property

Reference

Definition

Namespace:: System.Web.UI.WebControls

Assembly:: System.Web.dll

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.

Gets the connection string that is used to connect to the Microsoft Access database.

public:
 virtual property System::String ^ ConnectionString { System::String ^ get(); void set(System::String ^ value); };

[System.ComponentModel.Browsable(false)]
public override string ConnectionString { get; set; }

[<System.ComponentModel.Browsable(false)>]
member this.ConnectionString : string with get, set

Public Overrides Property ConnectionString As String

Property Value

String

The OLE DB connection string that the AccessDataSource control uses to connect to an Access database, through the System.Data.OleDb .NET data provider.

Attributes: BrowsableAttribute

Exceptions

InvalidOperationException

An attempt was made to set the ConnectionString property.

Examples

The following code example demonstrates how to display the ConnectionString property of the AccessDataSource control in an ASP.NET Web 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 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>

<%@ 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)

  Label1.Text = AccessDataSource1.ConnectionString

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:AccessDataSource
        id="AccessDataSource1"
        runat="server"
        DataFile="Northwind.mdb">
      </asp:AccessDataSource>

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

    </form>
  </body>
</html>

Remarks

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.

Applies to

Product	Versions
.NET Framework	2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1

The future is yours

Share via