( IDENTITY(1,1) NOT NULL, (20) NOT NULL, (10) NOT NULL, (30) NULL, (25) NULL, NULL, NULL, (60) NULL, (15) NULL, CONSTRAINT PRIMARY KEY CLUSTERED ( ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON ) ON GO SET IDENTITY_INSERT. Script to create the table: USE GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE. So I would like to set the sort on the HireDate column so that on page load it displays like this mockup:
So I think I have to set the sort on th fpspread grid. I tried setting Order By HireDate Descending in the stored procedure but that did not work. Then I bind the recordset to the fpspread grid. I have a stored procedure doing a Select * From Employees to return all the columns from this table.Then in vb6 application I have a function that calls this stored procedure and creates a record set. The Employees sql server table looks like this. If I was using the Employees table from the Northwind database, and my fpspread was called grdEmployees How would I set the sort on the fpspread so that on page load it is sorted by HireDate Descending ? I would like to set the sorting on the fpspread with code. In the fpspread documention for sorting, it mentions you can either sort using the Spread Designer or set the sorting programmatically with code. I want to sort it by one of the date columns. The data in the fpspread is not sorted on page load.
The data I used to fill the fpspread comes from a table in a sql server database. I have a form with a fpsread control on it, something like this: This is the user's guide for the fpspread control:
That is a grid that was used in old VB6 desktop applications I'm using farpoint fpspread grid control inside a old legacy VB6 application.
0 kommentar(er)
