Hey good people,
I hope you are all well. Ok so here is the scenario, i have 4 tables that i have made in sql server 2008. I am using a drop down menu to diplay their names. Like this...
I am going to use a dataGrid view. What i want to do is that when i select a department name from the drop down, it's table content shows up in the gridview that i can apply Datebase operations on, like add, edit, refresh and delete etc. I don't want to make seperate gridviews for each table.
Is this possible? and if yes, can you kindly guide me through?

Any kind of help is greatly appreciated!
thank you!

3 Years
Discussion Span
Last Post by ggamble

Yes, call a stored procedure in the database that will list out the columns you want. Bind the results to the DataGrid.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.