Welcome Guest Search | Active Topics | Sign In | Register

Essential Objects Product Support Forum » All Products » Support » grid object displaying data from SQL Server db

grid object displaying data from SQL Server db Options
Previous Topic · Next Topic
tim
Posted: Wednesday, February 17, 2010 1:04:50 AM
Rank: Member
Groups: Member

Joined: 3/29/2009
Posts: 29
Hi,
I am new to using the EO grid object.
I have a query that I have been displaying in the VS2005 "gridview" object that I would like to display in the EO "grid" object. I am hoping that EO will provide slicker end user features (scroll bars/sorting/etc) than the VS 2005 gridview can provide.

In order to assess this I need to get the grid object to return the data from this query:

select
DISTINCT(PROGRAM_TITLE) as [Program name],
PROGRAM_CATEGORY_NAME as [Category],
RIGHT(CONVERT(CHAR(8), DATEADD(SECOND, DEFAULTDURATION, '00:00'), 108), 7) AS [Duration],
live_selected_ind AS [Live],
record_selected_ind AS [Rec]
WHERE
station_id = 'tim'
ORDER BY program_title ASC

I am unclear as to how I set up the datasource link that would be needed for EO's grid.

If you could point me to a good example of getting data from SQL server and displaying the results in "grid" it would be great.
Thankyou.

Code: Visual Basic.NET 

    






    

        Code: Visual Basic.NET
        
        

    






    

        Code: Visual Basic.NET
        
        

    




		

			




	
		Back to top
	
	
		

		

			
			
			
			
			
			
			
			
			
			
			 

		

		

			








	
	



	
	
		
		eo_support
	

	
		

		

			
				Posted: 
				Wednesday, February 17, 2010 9:08:54 AM
			
			
				
				
				
				
			
		

		

			




	
		Rank: Administration
Groups: Administration




Joined: 5/27/2007
Posts: 24,194

			
		   
	    

		    Hi,

Your SQL is fine. However our Grid does not automatically generates columns. So you must define all the columns first.  The following link should give you step by step instructions on how to get it use our Grid:

http://doc.essentialobjects.com/library/1/grid/start.aspx

The sample project also has plenty of samples showing you how to populate the Grid from database. The Grid always takes data from an ADO.NET data object. So your backend database server type is irrelevant.

Thanks!
		

			




	
		Back to top
	
	
		

		

			
			
			
			
			
			
			
			
			
			
			 

		

		

			








	
	



	
	
		
		tim
	

	
		

		

			
				Posted: 
				Thursday, February 18, 2010 1:15:45 AM
			
			
				
				
				
				
			
		

		

			




	
		Rank: Member
Groups: Member




Joined: 3/29/2009
Posts: 29

			
		   
	    

		    great. Thanks. I have the data loading from SQL Server now.
		

			




	
		Back to top
	
	
		

		

			
			
			
			
			
			
			
			
			
			
			 

		

		

			









            











  

    
    
		
		
		
		
		
		












	You cannot post new topics in this forum.


You cannot reply to topics in this forum.


You cannot delete your posts in this forum.


You cannot edit your posts in this forum.


You cannot create polls in this forum.


You cannot vote in polls in this forum.