Click here to Skip to main content

chris.obrien.07 asked:

Open original thread
I have been creating an application recently and I need some help on database table schemas. I have programmed the application in vb.net 3.5 using a mysql database.
 
What the application does is not really important… except that I am trying to get the schema for a table in the database. To date the way I have been getting the schema for a table in the database is as follows
 
Dim conn As New MySqlConnection(ConnString) ‘ConnString is defined elsewhere
conn.Open()
Dim cmd As MySqlCommand = conn.CreateCommand
cmd.CommandText = "SELECT * FROM widgets WHERE widgetID=1"
 
‘Create a datareader and execute it
Dim dr As MySqlDataReader
dr = cmd.ExecuteReader()
 
‘Create a datatable to put the schema into
Dim dtSchema As New DataTable
dtSchema = dr.GetSchemaTable
I am seeking a way of getting the schema for the table above without having to execute the select command. This will help me in my quest to make my app work with more than one DB provider. I don’t want my app to have any SQL commands if at all possible. (my intention is to only use stored procedures in the database)
 
Any help is appreciated
Tags: SQL, VB.NET

Preview



When answering a question please:
  1. Read the question carefully.
  2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
  3. If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Let's work to help developers, not make them feel stupid.
Please note that all posts will be submitted under the The Code Project Open License (CPOL).



Advertise | Privacy | Mobile
Web04 | 2.8.140905.1 | Last Updated 26 Mar 2009
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100