SqlCeResultSet.GetSqlMetaData 方法

返回与指定的列相关联的元数据信息。

命名空间: System.Data.SqlServerCe
程序集: System.Data.SqlServerCe（在 system.data.sqlserverce.dll 中）

语法

声明
Public Function GetSqlMetaData ( _
    ordinal As Integer _
) As SqlMetaData
用法
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

不适用。

参数

• ordinal
  将从其中检索数据的列的序号位置。

返回值

位于指定索引处的列的元数据。

备注

如果在指定的序号位置不存在任何字段，则会引发异常。

示例

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

SqlCeConnection conn = null;

try
{
    File.Delete("Test.sdf");

    SqlCeEngine engine = new SqlCeEngine("Data Source = Test.sdf");
    engine.CreateDatabase();

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

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

    cmd.CommandText = "SELECT * FROM myTable";

    SqlCeResultSet rs = cmd.ExecuteResultSet(ResultSetOptions.Updatable | 
        ResultSetOptions.Scrollable);

    SqlMetaData columnMetaData = rs.GetSqlMetaData(2 /*ordinal*/);

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

}
catch (Exception e)
{
    MessageBox.Show(e.Message);
}
finally
{
    conn.Close();
}

平台

Windows 98, Windows Server 2000 SP4, Windows CE, Windows Millennium Edition, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

Windows Vista、Microsoft Windows XP SP2 和 Windows Server 2003 SP1 支持 Microsoft .NET Framework 3.0。

版本信息

.NET Framework

受以下版本支持：3.0

.NET Compact Framework

受以下版本支持：2.0

请参见

参考

SqlCeResultSet 类
SqlCeResultSet 成员
System.Data.SqlServerCe 命名空间