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!

Re: Binding a grid view with multiple tables?? 80 80

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.