Click here to Skip to main content
Rate this: bad
good
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
v2

1 solution

Rate this: bad
good
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))
 
AS
 
  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 
 
go

Hope this helps
--Rahul D.
  Permalink  

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



Advertise | Privacy | Mobile
Web03 | 2.8.1411022.1 | Last Updated 9 Jan 2013
Copyright © CodeProject, 1999-2014
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