Working With ADOX and Combo Box Control
(Page 1 of 5 )
This article has 2 parts: The first part on ADOX provides information and code regarding the database, tables, stored procedures and views. In the second part the author provides a quick implementation on how to use the new .Net Combo Box.
Support files are available here for the ADOX files, and here for the Combo Box files.
Working With ADOX Visual Studio .Net has come with a very useful Add-In -- the Server Explorer. We will not be discussing it in detail, but I will talk a little bit about the Data connection.
Have you ever thought about how they made it? If not, have you been wondered when working with the SQL Enterprise Manager when it displays the system tables that you don’t want to see?
In this article, we will make the very first step in a tool that you have the control of. You can also customize this tool to speed up your development process.
Since we are working with .NET, I'm sure you have used the ADO.NET, and before that the great ADO. But as a matter of fact, these tools didn’t give us any information about the database, the tables, stored procedures, or views.
I will have to agree that when we use SQL server, we can run some queries against the system tables, and we will get much of the information that we need. But this is now how the Server Explorer works -- it can connect to virtually any database that supports OLE DB and many others.
So, what should we do?
We have to roll back to the ADO, but don’t worry, we will use it and X this time. Our solution has been there for a while, ADOX.
ADOX is a COM component that has a very rich object model. You can check it out at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/admscobjectmodel.asp
Let's see some code. After all, don’t we all like to talk code?
Next: Code >>
More Database Articles
More By Mohammed Qattan
/ 10 
