PC Review


Reply
Thread Tools Rate Thread

dataset schema information

 
 
ed
Guest
Posts: n/a
 
      23rd Jul 2003
The oleDBdatareader provides a GetSchemaTable() method that returns a
dataTable.
Consider the following statement for a datatable called dTable constucted
through GetSchemaTable():
dTable.Rows(0).Item(dTable.Columns("ProviderType")).ToString()

This statement would return a value of "202" if the first column was
datatype nvarchar in the sql server database.

How can I, using a dataset instead of a datareader, return this ProviderType
value (202) for a nvarchar SQL server column?

I don't want to have to resort to some mapping solution, e.g.,
"string"=>202.

Thanks in advance.


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I sync a typed dataset schema with database schema easily? John Microsoft Dot NET 1 2nd Jan 2008 10:37 AM
Dataset Schema from XSD MR Microsoft C# .NET 3 10th Aug 2005 09:21 AM
DataSet ReadXmlSchema fails on a schema with (xsd:)imported schema Eric van Wijk Microsoft ADO .NET 0 27th Jul 2004 05:14 PM
Unable to Retrieve Schema Information while retrieving a DataSet ! =?Utf-8?B?U2F1cmFiaA==?= Microsoft ADO .NET 0 1st Jul 2004 07:56 AM
Re: dataset schema Cor Microsoft ADO .NET 0 25th Mar 2004 09:45 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:02 AM.