Member Avatar for sana.f.qureshi_1

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...
ecb53783b16f2f19f927a3cd72bee4d0
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!

  • 2 Contributors
  • 1 Reply
  • 295 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by BMXDad
Member Avatar for BMXDad

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.