By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 943 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Data & Table

P: 56
I have a form where in there are several command buttons. the command buttons bore names of various tables in the database. when a particular button is clicked on i want that table to be displayed in a tabular format to the user. what should i do???
Jan 23 '08 #1
Share this Question
Share on Google+
4 Replies


debasisdas
Expert 5K+
P: 8,127
You need to dynamically pass the table names to database using SQL query .
Fetch data and display in some grid control.
Jan 23 '08 #2

P: 56
i just found that there are 115 tables.....ofcourse i cannot make 115 command buttons....what should i ideallly do???.....is ther some other way for letting the user view the data in the database which can be simpler?
Jan 23 '08 #3

QVeen72
Expert 100+
P: 1,445
Hi,

Place a DataGrid, and Open a Connection Object,
Open a Recordset for the Command's Caption, and Set the Datagrid's Source..
Refresh DataGrid..

REgards
Veena
Jan 23 '08 #4

debasisdas
Expert 5K+
P: 8,127
i just found that there are 115 tables.....ofcourse i cannot make 115 command buttons....what should i ideallly do???.....is ther some other way for letting the user view the data in the database which can be simpler?
place a listbox on the form and populate the control with name of tables in the database.

on selection in the lisbox ,pass the tablename and open the recordset.
display the fetched data in a grid control.
Jan 23 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.