IDbViewManager.CreateView Method (Microsoft.Web.Management.DatabaseManager)

MSDN Library
Web Development
Internet Information Services (IIS)
Internet Information Services Extensions
Microsoft.Web.Management.DatabaseManager Namespace
IDbViewManager Interface
IDbViewManager Methods

CreateView Method

DropView Method
EditView Method
GetViews Method

IDbViewManager..::.CreateView Method

.NET Framework Class Library

IDbViewManager..::.CreateView Method

Creates a view within the database.

Namespace: Microsoft.Web.Management.DatabaseManager
Assembly: Microsoft.Web.Management.DatabaseManager (in Microsoft.Web.Management.DatabaseManager.dll)

Syntax

C++

JScript

Copy to Clipboard Print

'Usage

Dim instance As IDbViewManager
Dim connectionString As String
Dim schema As String
Dim view As View

instance.CreateView(connectionString, _
    schema, view)

'Declaration

Sub CreateView ( _
    connectionString As String, _
    schema As String, _
    view As View _
)

Parameters

connectionString: Type: System..::.String
The connection string for the database.

schema

Type: System..::.String
The schema name for the view.

Note:
If schema is empty, the default schema name will be used.

view: Type: Microsoft.Web.Management.DatabaseManager..::.View
The View object for the view to create.

Remarks

All database providers that implement the IDbViewManager interface must also implement the CreateView method, which the database manager will use to create a view in a database.

Notes for Implementers

If your provider does not support creating views, you can use the following code sample to raise a not-implemented exception:

public void CreateView(string connectionString, string schema, View view)

{

throw new NotImplementedException();

}

Note:
See the CREATE VIEW (Transact-SQL) topic for more information about the CREATE VIEW SQL statement.

Examples

The following code sample implements the CreateView method to add a view to a database in an OLEDB data source.

C++

JScript

Copy to Clipboard Print


    ' Remove a view from the database.
    Public Sub DropView( _
            ByVal connectionString As String, _
            ByVal schema As String, _
            ByVal viewName As String) _
            Implements Microsoft.Web.Management.DatabaseManager.IDbViewManager.DropView

        ' Create a new database connection.
        Dim connection As OleDbConnection = New OleDbConnection(connectionString)
        ' Create the SQL for the CREATE VIEW statement.
        Dim dropView As String = String.Format("DROP VIEW {0}", EscapeName(viewName))
        ' Create an OLEDB command object.
        Dim command As OleDbCommand = New OleDbCommand(dropView, connection)
        ' Open the database connection.
        connection.Open()
        ' Execute the SQL statement.
        command.ExecuteNonQuery()

    End Sub

Permissions

Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see .

Reference

IDbViewManager Interface

IDbViewManager Members

Microsoft.Web.Management.DatabaseManager Namespace