Click here to Skip to main content
11,921,870 members (65,220 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
Edited 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
0 OriginalGriff 538
1 Dave Kreskowiak 260
2 Sergey Alexandrovich Kryukov 173
3 phil.o 170
4 RyanDev 134
0 OriginalGriff 7,036
1 KrunalRohit 4,530
2 Sergey Alexandrovich Kryukov 3,286
3 George Jonsson 2,840
4 Suvendu Shekhar Giri 2,216

Advertise | Privacy | Mobile
Web01 | 2.8.151120.1 | Last Updated 9 Jan 2013
Copyright © CodeProject, 1999-2015
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