I want to get all the tables name of a database in a combo box, can u help me please.......
Printable View
I want to get all the tables name of a database in a combo box, can u help me please.......
Use this query for the CommandText property of your selectcommand:
[U]
select name from sysobjects where xtype='U' [/U]
this works in MS sql server.
whether it solve the problem do inform me.
[QUOTE=bhaskarjha;10084]Use this query for the CommandText property of your selectcommand:
[U]
select name from sysobjects where xtype='U' [/U]
this works in MS sql server.
whether it solve the problem do inform me.[/QUOTE]
thanx bhaskarjha it works successfully in my system.