<div>
By default, ADO.Net the DataAdapter's Fill() method takes a &quot;short cut&quot; and only pulls the bare bones information required to populate the DataTable. &nbsp;<br />
<br />
To get the fully populated schema (which includes the column widths) just add the following:<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DataAdapter.MissingSchemaA<wbr />ction = MissingSchemaAction.AddWit<wbr />hKey<br />
<br />

</div>


By default, ADO.Net the DataAdapter's Fill() method takes a "short cut" and only pulls the bare bones information required to populate the DataTable.  

To get the fully populated schema (which includes the column widths) just add the following:

           DataAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey



<div>
Thank you for that, Graye.<br />
<br />
However, dr.Table.Columns(Ind).Data<wbr />Type.ToStr<wbr />ing still returns &quot;System.String&quot;, if the column is varchar or ntext.<br />
<br />
Is it possible to get the Data Type from the table in the SQL database?<br />

</div>


Thank you for that, Graye.

However, dr.Table.Columns(Ind).DataType.ToString still returns "System.String", if the column is varchar or ntext.

Is it possible to get the Data Type from the table in the SQL database?


<div>
<div class="content wysiwyg-content">
To store a string in a varchar field the maximum length of string is needed to avoid a data-truncation error.<br />
<br />
The following code only returns -1 if the column is varchar or ntext:<br />
<br />
dr.Table.Columns(Ind).MaxL<wbr />ength<br />
<br />
where Ind is the index of the required column.<br />
<br />
dr.Table.Columns(Ind).Data<wbr />Type.ToStr<wbr />ing only returns &quot;System.String&quot;, if the column is varchar or ntext.<br />
<br />
What is the equivalent of the VB6 Fd.DefinedSize (where Fd is ADODB.Field)?
</div>
</div>


To store a string in a varchar field the maximum length of string is needed to avoid a data-truncation error.

The following code only returns -1 if the column is varchar or ntext:

dr.Table.Columns(Ind).MaxLength

where Ind is the index of the required column.

dr.Table.Columns(Ind).DataType.ToString only returns "System.String", if the column is varchar or ntext.

What is the equivalent of the VB6 Fd.DefinedSize (where Fd is ADODB.Field)?

MaxLength for varchar column

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,