How do I call Table into Datagridview Using Textbox input for TableName?

Question

0.00/5 (No votes)

See more:

Hi Experts.

I have Mutliple Tables in My Access Database with passport No. as Table Names. And All Tables have same Columns.

Now My Question is How could i call particular table into DataGridview.

Example : I have taken 1 TextBox, 1 Button, And 1 DataGridview.

When I Enter Passport No. in TextBox and Clicking on Button, The DataGridView is to be updated with particular Passport No's Table().

Please give suggestion or any reference to get solution.

Thanks in Advance..

I am New to Dotnet. Please dont Missunderstand for my question.
At least i am not getting how start code it.

Posted 25-Dec-14 20:59pm

satya.Sw

Add a Solution

1 solution

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)

DamithSL · Answer 1 · 2014-12-25T21:15:00

first of all you better change your table design to having single table for all the passport No/Type.

example :

TableforType1
Col1           col2
val11            val12

TableforType2
Col1           col2
va21            val22

can be change to MyTable

TypeID     Col1      col2
1          val11     val12
2          val21     val22
3          val31     val32
1          val12     val13

TypeTable
ID      TypeName
1       Type A
2       Type B
3       New Type

by using above two tables you can handle many types without creating new tables for each new type.

when you need to retrieve data for type 1 for example ;

SQL

select m.Col1, m.col2 from MyTable m join TypeTable t on m.TypeId = t.ID where t.TypeName ='Type A'

so you don't need build runtime sql statements or creating complex logic on deciding which database table to select.