-
October 13th, 2013, 01:09 PM
#1
Getting DataTypeName of each column of table
Hi there ,
I have this code :
Dim query As String = "show columns from " & table_name & " from " & db_name
Dim connection As New MySqlConnection(cons)
Dim cmd As New MySqlCommand(query, connection)
connection.Open()
Dim reader As MySqlDataReader
reader = cmd.ExecuteReader()
MessageBox.Show(reader.FieldCount)
For i As Integer = 0 To reader.FieldCount - 1
MessageBox.Show(reader.GetDataTypeName(5))
Next
I want to show the field's type of each column of the table , the problem is that FieldCount is incorrect , I do have fields more than VB.NET shows me.
any solutions ?
thanks.
-
October 13th, 2013, 08:49 PM
#2
Re: Getting DataTypeName of each column of table
That is a very odd looking query, I would expect that to crash.
Select * from TableName
Would select all of the columns
Always use [code][/code] tags when posting code.
-
October 14th, 2013, 02:42 AM
#3
Re: Getting DataTypeName of each column of table
mysql> select * from teachers;
Empty set (0.00 sec)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|