Home - Forums-.NET - FlyGrid.Net (Windows Forms) - Problem with sort

FlyGrid.Net (Windows Forms)

.NET Datagrid - Fast, highly customizable, industry standards .NET data grid control for WinForms

This forum related to following products: FlyGrid.Net
Problem with sort
Link Posted: 23-Jan-2006 10:58
Anonymous avatar
Anonymous
Total Posts:0
Joined:4/4/2025
Hi,

we have a searching sub like this:

Private Sub Search()
  RemoveDatasource()
  PrepareSelectCommand(PrepareExp())
  FillDataset()
  SetDatasource()
End Sub

It works fine until the user doesn't sort by a specific column. If the user sort by a column and then make another search we get the error "cannot find column xxx" where xxx is the sort column.

I try to clean the SortColumns array but it doesn't solve.

Can you help me!

Roberto
Link Posted: 23-Jan-2006 16:29
NineRays avatar
NineRays
Total Posts:0
Joined:4/4/2025
Please download latest FlyGrid.Net 1.2.14, problem with .SortColumns is solved int this version.
Link Posted: 23-Jan-2006 21:55
Anonymous avatar
Anonymous
Total Posts:0
Joined:4/4/2025
Hi,

I have downloaded but I still have the problem.

It's necessary to clean the SortColumns array or not?

Thanks
Link Posted: 24-Jan-2006 08:44
NineRays avatar
NineRays
Total Posts:0
Joined:4/4/2025
1. try to enclose your initialization procedures into BeginInit/EndInit methods as shown below:
[VB.Net]
Private Sub Search()
  Me.FlyGrid1.BeginInit()
  Try
    RemoveDatasource()
    PrepareSelectCommand(PrepareExp())
    FillDataset()
    SetDatasource()
  Finally
    Me.FlyGrid1.EndInit()
  End Try
End Sub
Link Posted: 02-Feb-2006 07:36
repoleved avatar
repoleved
Total Posts:0
Joined:4/4/2025
We fixed this problem by setting the data member property before setting the data source:


flyGrid.DataSource = null;
//Create Columns and/or set Sort Order
flyGrid.DataMember = tableName;
flyGrid.DataSource = dataSet;
Share:

Company  |  Privacy  |  Legal Information

© 1999-2025 9Rays.Net. All rights reserved.