Click here to Skip to main content
12,750,710 members (37,580 online)
Rate this:
Please Sign up or sign in to vote.
See more: C# Windows Application
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

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 | Mobile
Web02 | 2.8.170215.1 | Last Updated 9 Jan 2013
Copyright © CodeProject, 1999-2017
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