SqlCeResultSet.GetSqlMetaData Method

Article
10/22/2007

Returns the metadata information associated with the specified column.

Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)

Syntax

'Declaration
Public Function GetSqlMetaData ( _
    ordinal As Integer _
) As SqlMetaData
'Usage
Dim instance As SqlCeResultSet
Dim ordinal As Integer
Dim returnValue As SqlMetaData

returnValue = instance.GetSqlMetaData(ordinal)

public SqlMetaData GetSqlMetaData (
    int ordinal
)

public:
SqlMetaData^ GetSqlMetaData (
    int ordinal
)

public SqlMetaData GetSqlMetaData (
    int ordinal
)

public function GetSqlMetaData (
    ordinal : int
) : SqlMetaData

Parameters

ordinal
The ordinal position of the column from which to retrieve data.

Return Value

The metadata of the column at the specified index.

Remarks

An exception is thrown if no field exists at the specified ordinal position.

Example

Dim conn As SqlCeConnection = Nothing

Try
    File.Delete("Test.sdf")

    Dim engine As New SqlCeEngine("Data Source = Test.sdf")
    engine.CreateDatabase()

    conn = New SqlCeConnection("Data Source = Test.sdf")
    conn.Open()

    Dim cmd As SqlCeCommand = conn.CreateCommand()
    cmd.CommandText = "CREATE TABLE myTable (col1 INT, col2 MONEY, col3 NVARCHAR(200))"
    cmd.ExecuteNonQuery()

    cmd.CommandText = "SELECT * FROM myTable"

    Dim rs As SqlCeResultSet = cmd.ExecuteResultSet(ResultSetOptions.Updatable Or ResultSetOptions.Scrollable)

    Dim columnMetaData As SqlMetaData = rs.GetSqlMetaData(2) 'ordinal

    MessageBox.Show("Column Name = " & columnMetaData.Name)
    MessageBox.Show("Max Length = " & columnMetaData.MaxLength)
    MessageBox.Show("Type = " & columnMetaData.SqlDbType)

Catch e As Exception
    MessageBox.Show(e.Message)
Finally
    conn.Close()
End Try

.NET Framework Security

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

Platforms

Windows CE, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows XP Professional x64 Edition, Windows XP SP2

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

Version Information

.NET Compact Framework

Supported in: 2.0

Share via