SqlCeResultSet.GetSqlMetaData Método
Devuelve la información de metadatos asociada a la columna especificada.
Espacio de nombres: System.Data.SqlServerCe
Ensamblado: System.Data.SqlServerCe (en System.Data.SqlServerCe.dll)
Sintaxis
'Declaración
Public Function GetSqlMetaData ( _
ordinal As Integer _
) As SqlMetaData
'Uso
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
)
member GetSqlMetaData :
ordinal:int -> SqlMetaData
public function GetSqlMetaData(
ordinal : int
) : SqlMetaData
Parámetros
- ordinal
Tipo: System.Int32
Posición ordinal de la columna de la que se van a recuperar datos.
Valor devuelto
Tipo: System.Data.SqlServerCe.SqlMetaData
Metadatos de la columna correspondiente al índice especificado.
Comentarios
Si no existe ningún campo en la posición ordinal especificada, se produce una excepción.
Ejemplos
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();
}