Field size in ADO.NET?

[Wael Soliman]

Hi all
In vb6 using ADO I can get the field size from recordset
for example: Size = Recordset.Fields(index).DefinedSize
How can I do it in vb.net using ADO.NET
Best regards

 

[Cor]

Hi Wael,

Have a look at the datacolumn class,
http://msdn.microsoft.com/library/d.../html/frlrfSystemDataDataColumnClassTopic.asp
I hope this helps?

Cor

 

[Sameh Refaat]

Hi Wael
You can get information needed by using
table schema with the FillSchema method of the DataAdapter


Dim da As SqlClient.SqlDataAdapter
Dim ds As New DataSet
Dim con As SqlClient.SqlConnection

Try
Dim con As New SqlClient.SqlConnection("Your connection ")
Dim da As New SqlClient.SqlDataAdapter(TableName , con)
da.FillSchema(ds, SchemaType.Source, "Schema")

' Field Length = ds.Tables("schema").Columns(FieldName).MaxLength

Catch ex As System.Exception
MsgBox(ex.Message)
End Try

Best regards
Sameh Refaat