how to get number of column in mysql using vb6

Question

0.00/5 (No votes)

See more:

i would like to know if there any ways to count the column in table in vb6, because i'd try find it but i just can get the row counting and field count....

i'm using ADODB,mySQL and VB6...

another is, i'm using OPENSCHEMA method to get the column name, is there any other way than using OPENSCHEMA?

Posted 11-Sep-13 18:32pm

_nurhan

Add a Solution

3 solutions

Solution 3

http://p2p.wrox.com/access-vba/38222-column-name-adodb-recordset.html[^]

=) same as what thatraja gave me

Posted 12-Sep-13 23:16pm

_nurhan

Solution 1

load all data to datatable

int colmcount=datatable.Columns.Count;

Posted 11-Sep-13 19:18pm

murkalkiran

Comments

thatraja 12-Sep-13 7:17am

Obviously you're not a golfer - Jeff Lebowski

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
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.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Accepted Answer · 2013-09-12T01:28:00

Solution 2

Unfortunately I don't have experience in ADODB, check these

Column Name from ADODB Recordset[^]
When you get column collection then you get the column count.
Counting the Number of Records in a Recordset ^]

Nice suggestion : Go with .NET instead of playing with VB6.

Posted 12-Sep-13 1:28am

thatraja

Comments

_nurhan 13-Sep-13 5:14am

thatraja, really thank you

i'd done using openschema method, and from there i'm just get the number of column from that...

i'm just curious why you ask me to use .NET instead of VB6...so far the difference between these two is syntax *so far i know only that. why u said it is nice suggestion?

thatraja 7-Oct-13 14:31pm

VB6 & Classic ASP are old things. So I told you to go with better alternatives(.NET) which has more features. It's for your own good. If you want more details, let me know, I could give you more details.