Click here to Skip to main content
15,918,109 members
Home / Discussions / C#
   

C#

 
GeneralRe: connection string Pin
Christian Graus24-Mar-08 18:44
protectorChristian Graus24-Mar-08 18:44 
GeneralRe: connection string Pin
blue124-Mar-08 19:38
blue124-Mar-08 19:38 
GeneralRe: connection string Pin
Christian Graus24-Mar-08 21:09
protectorChristian Graus24-Mar-08 21:09 
GeneralDesign Pin
BlitzPackage24-Mar-08 14:30
BlitzPackage24-Mar-08 14:30 
GeneralRe: Design Pin
Colin Angus Mackay24-Mar-08 14:33
Colin Angus Mackay24-Mar-08 14:33 
GeneralRe: Design Pin
BlitzPackage24-Mar-08 14:49
BlitzPackage24-Mar-08 14:49 
GeneralRe: Design Pin
Thomas Stockwell25-Mar-08 4:42
professionalThomas Stockwell25-Mar-08 4:42 
GeneralLocate row in Virtual DataGridView from server Pin
AndrusM24-Mar-08 11:09
AndrusM24-Mar-08 11:09 
I use WinForms DataGridView in Virtual mode based on MSDN samples.
Grid data is cached in paged List<TEntity>
Data is retrieved in OnCellValueNeeded() event
using DLinq Skip()/Take() methods from server database.

I have implemented column search feature which allows to locate row whose
column contain sertain value.

I use DataGridView method for it:

void LocateInColumn() {<br />
<br />
SearchFor = Microsoft.VisualBasic.Interaction.InputBox(<br />
          Columns[CurrentCell.ColumnIndex].HeaderText,<br />
          "Locate value",<br />
              "", -1, -1);<br />
<br />
int col = CurrentCell.ColumnIndex;<br />
for (int i = CurrentRow.Index + 1; i < RowCount - 1; i++) {<br />
   object val = this[col, i].Value;<br />
   if (val == null) continue;<br />
   if (val.ToString().ToUpper().<br />
                        Contains(SearchFor.ToUpper())) {<br />
      CurrentCell = this[col, i];<br />
      return;<br />
   }<br />
 }<br />
MessageBox.Show("Not found");<br />
}


This code causes all data to be readed over internet connection and is very slow.
I cannot use Where clause directly since I need to show also rows before and next located row.
How to locate row without reading whole database ?
I can use where clause to find row id. However I have no idea how to position virutal grid to this row
so that rows before and after are also visible.

Is it possible to implement in easily in some other GUI: GTK#, Silverlight, WPF ?
Are there any grid control available which implements this ?

Andrus

Generaldisabling highlighting of current cell in DataGridView Pin
AndrusM24-Mar-08 11:08
AndrusM24-Mar-08 11:08 
GeneralRe: disabling highlighting of current cell in DataGridView Pin
C1AllenS24-Mar-08 11:33
C1AllenS24-Mar-08 11:33 
QuestionRe: disabling highlighting of current cell in DataGridView Pin
AndrusM25-Mar-08 9:23
AndrusM25-Mar-08 9:23 
GeneralNeed Help for Program Call Extension File in C#.. Pin
pakpatel24-Mar-08 10:56
pakpatel24-Mar-08 10:56 
GeneralRe: Need Help for Program Call Extension File in C#.. Pin
Christian Graus24-Mar-08 11:00
protectorChristian Graus24-Mar-08 11:00 
QuestionHow To Separate Number ? Pin
pakpatel24-Mar-08 10:48
pakpatel24-Mar-08 10:48 
AnswerRe: How To Separate Number ? Pin
Christian Graus24-Mar-08 11:00
protectorChristian Graus24-Mar-08 11:00 
GeneralRe: How To Separate Number ? Pin
pakpatel24-Mar-08 11:51
pakpatel24-Mar-08 11:51 
GeneralRe: How To Separate Number ? Pin
Christian Graus24-Mar-08 11:54
protectorChristian Graus24-Mar-08 11:54 
GeneralRe: How To Separate Number ? Pin
PIEBALDconsult24-Mar-08 12:50
mvePIEBALDconsult24-Mar-08 12:50 
GeneralRe: How To Separate Number ? Pin
Christian Graus24-Mar-08 13:01
protectorChristian Graus24-Mar-08 13:01 
GeneralRe: How To Separate Number ? Pin
PIEBALDconsult24-Mar-08 13:13
mvePIEBALDconsult24-Mar-08 13:13 
GeneralRe: How To Separate Number ? Pin
Christian Graus24-Mar-08 13:25
protectorChristian Graus24-Mar-08 13:25 
GeneralRe: How To Separate Number ? Pin
pakpatel24-Mar-08 19:12
pakpatel24-Mar-08 19:12 
GeneralRe: How To Separate Number ? Pin
Vikram A Punathambekar25-Mar-08 2:47
Vikram A Punathambekar25-Mar-08 2:47 
GeneralRe: How To Separate Number ? Pin
PIEBALDconsult25-Mar-08 5:04
mvePIEBALDconsult25-Mar-08 5:04 
GeneralHelp Pin
Grim Re@p3r24-Mar-08 10:47
Grim Re@p3r24-Mar-08 10:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.