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
)
member GetSqlMetaData :
ordinal:int -> SqlMetaData
public function GetSqlMetaData(
ordinal : int
) : SqlMetaData
パラメーター
- ordinal
型: System. . :: . .Int32
データの取得元となる列の序数位置。
戻り値
型: System.Data.SqlServerCe. . :: . .SqlMetaData
指定したインデックス位置にある列のメタデータ。
説明
指定した序数位置にフィールドが存在しない場合、例外がスローされます。
使用例
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();
}