Using cn As New OleDbConnection(ConnectionString) New DataColumn( 'DataType', GetType(System. New DataColumn( 'ColumnName', GetType(System. Here is a line of code that retrieves the details for a datatable named 'Employees'.ĭataTable schemaTable = cn.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, New Object() Here's a link that appears in that thread explains the GetSchema method in detail. However, as garbled as the thread may appear, all of the C# code is still visible. Other threads with the sample code either disappeared, or 'Search' does not return them in the results. The thread with the sample became corrupted after going through a couple of forum migrations One of those links is to a database oriented forum where I posted a sample C# form to allow you to 'practice' at callling the method and seeing the results. The thread at the previous link contains several links in my reply marked as answer. It takes some practice to climb the learning curve. Anyone can tell you how to ride a bike, but you will not 'know how' ride a bike until you get on it and fall off a few times. The only way to truly understand it is to play with The size of the restrictions array can vary in size, depending upon which schema you are trying to get. You must make repeated calls with the method to 'drill down' to the information you seek. See this thread for an explanation of how it works. The 'GetSchema' methods are some of the most unusual methods that I have found in the entire Framework. For this reason, websites hosted on Microsoft Windows servers often use Access databases for generating dynamic content.I feel your pain and frustration. In fact, Microsoft FrontPage and Expression Web, as well as ASP.NET have built-in support for Access databases. This compatibility also enables Access to serve as the back end for a database-driven website. This allows data to be sent to and from other database programs, such as MS SQL, FoxPro, Filemaker Pro, and Oracle databases.

While Access is a proprietary database management system ( DBMS), it is compatible with other database programs since it supports Open Database Connectivity ( ODBC). The information stored within an Access database can be browsed, searched, and accessed from other programs, including Web services. Data can be entered into an Access database using either visual forms or a basic spreadsheet interface. The program also provides a visual interface for creating custom forms, tables, and SQL queries. Access allows users to create custom databases that store information in an organized structure. Microsoft Access, often abbreviated 'MS Access,' is a popular database application for Windows.

Microsoft access data types definition