Retrieving Database Schema Information using the OleDbSchemaGuid Class: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
Retrieving Database Schema Information using the OleDbSchemaGuid Class

page 4 of 4

by Steven Swafford
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 25987/ 74

Article Contents:

Introduction
Establish a Connection to the Access Database
Create the Web Form
Conclusion

Conclusion

To recap, we have looked at the ability to retrieve schema information from an Access database, by using the GetOleDbSchemaTable method and OleDbSchemaGuid class within the System.Data.OleDb namespace. Be sure to take the time to read over the following references.

.NET References

Listbox Class	DataGrid Class	Label Class
Panel Class	Button Class	GetOleDbSchemaTable Method
OleDbConnection Class	OleDbSchemaGuid Fields	DataTable Class
OnSelectedIndexChanged Method	DataSet Class	OleDbDataApter Class
System.Data.OleDb Namespace

Other Articles of Interest

.NET Data Provider Connection Strings
A much needed SchemaHelper class
Using Database Schema Information with ASP.NET
HOW TO: Retrieve Meta Data from Excel by Using GetOleDbSchemaTable in Visual C# .NET