Data Type Mapping. SQL Data Types for MS Access, MySQL, and SQL Server. Form1. FormReadAccessDB. Welcome to Ohloh Code, the world’s largest, most comprehensive free code search engine! Koders has now merged with Ohloh to become your one-stop resource for both code and analysis. Check out our FAQ for more info. Other operators: ctor: Constructor definitions edef: Enum definitions ctordec: Constructor declarations fdef: Field definitions dtor: Destructor definitions odef: Object definitions dtordec: Destructor declarations tdef: Type definitions fndec: Function declarations udef: Union definitions mdec: Method declarations.
ADO OpenSchema in CSharp. ADO OpenSchema in CSharp Sahir Shah 10-January-2006 Download source code Introduction ADO Connection object's OpenSchema method is one way of obtaining information about tables in a database and fields in a table. Most of the examples given in MSDN resources deal with using these methods in Visual Basic and Visual C++ 6. Listing Tables To list tables in the database we connect to the database and then call OpenSchema on the connection object. ADODB.Recordset rs; ADODB.Connection connObj = new ADODB.ConnectionClass(); connObj.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:/db1.mdb;"; connObj.Open(null, null , null , 0); if(connObj.State ! This call returns a recordset object which contains the following fields : The TABLE_TYPE field can contain the values : TABLE, VIEW , ACCESS TABLE and SYSTEM TABLE.
Listing Fields The returned recordset contains the following fields : The fields likely to be of interest are COLUMN_NAME , DATA_TYPE and CHARACTER_MAXIMUM_LENGTH. Home. ADO Data Types.