Click here to Skip to main content
11,804,008 members (79,381 online)
Rate this: bad
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 21:20pm
Edited 8-Jan-13 21: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 410
1 CPallini 310
2 Sergey Alexandrovich Kryukov 234
3 CHill60 230
4 Suvendu Shekhar Giri 200
0 OriginalGriff 3,140
1 Maciej Los 1,910
2 KrunalRohit 1,907
3 CPallini 1,845
4 Richard MacCutchan 1,187

Advertise | Privacy | Mobile
Web03 | 2.8.151002.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