sql query in the SqlDataAdapter()

Question

Im using c# .net windows form application. I have loaded names of all the tables present in a database into a combobox.

Now i need to display the contents of the selected table name.

Normally we use

SqlDataAdapter adp= new SqlDataAdapter("Select * from employee", con);

This works fine. but instead of explicitly giving table name i.e employee i need to set it to combobox1.selected item.

I have given like this its not working: string filename= combobox1.selecteditem; SqlDataAdapter adp= new SqlDataAdapter("Select * from filename", con);

How can I select filename dynamically?

Hun1Ahpu · Accepted Answer · 2010-04-14 11:34:34Z

1

I think this should look like:

string filename= combobox1.selecteditem.ToString();
SqlDataAdapter adp= new SqlDataAdapter("Select * from "+filename, con);

answered Apr 14, 2010 at 11:34

Hun1Ahpu

3,3753 gold badges30 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

svick · Accepted Answer · 2010-04-14 11:33:28Z

0

Just use string concatenation, if you're not afraid of SQL injection:

SqlDataAdapter adp = new SqlDataAdapter("Select * from " +  combobox1.selecteditem, con);

answered Apr 14, 2010 at 11:33

svick

247k54 gold badges407 silver badges535 bronze badges

Collectives™ on Stack Overflow

sql query in the SqlDataAdapter()

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related