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!