Click here to Skip to main content
13,355,292 members (63,181 online)
Rate this:
Please Sign up or sign in to vote.
Hi I retreived database tablenames and populated into combobox.and i using gridview in my application.i want to display the table in gridview based on the tablename selected by the user which is in combobox.How to do this?
Posted 8-Jan-13 22:20pm
Updated 8-Jan-13 22:25pm
pranathis012 9-Jan-13 3:23am
So, what's the problem now...?

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

As you already aware of programming and how to access database . I would suggest you to create below procedure and run this from your code with parameter as your user selection from combobox

CREATE PROC [spGetTableData]( @tblname nvarchar(MAX))
  declare @cmd nvarchar(max)
  declare @parameters nvarchar(max)
  set @cmd = N'SELECT * FROM @tblname'
  set @parameters = '@tblname nvarchar(MAX)'
  EXEC sp_executesql @cmd, @parameters, @tblname = @tblname 

Hope this helps
--Rahul D.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web04 | 2.8.180111.1 | Last Updated 9 Jan 2013
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100