DataGrid: Custom ComboBox column problem

[TT (Tom Tempelaere)]

Hay there,

I'm writing my own DataGridComboBo xColumn because .NET 1.1 does not have one
(I hope .NET 2.0 supplies one). I based it on this article:
http://msdn.microsoft.com/msdnmag/is...s/default.aspx

I have a problem when there are two DataGrid's on one form, and when I
switch focus from one grid to the other. To be more precise, when I'm editing
a combo box column in one grid, and then click in the combo column of another
grid an exception is thrown stating "The ListManager's position must be equal
to rowNum.
Parameter name: rowNum".

I will post the code if anyone feels like digging into it. Anyway, perhaps
someone has a better link with a how-to?

Notes about the code:
* The only thing that the PropertyEditorT able is used for in this context is
for setting the DataSource of the ComboBox that edits the value.
* The exception occurs when executing SetColumnValueA tRow in the
comboBox_Leave event handler

internal class PropertyComboBo xColumn : DataGridTextBox Column
{
protected PropertyEditorT able pe;
private ComboBox comboBox;
private CurrencyManager cm;
private int iCurrentRow;

public ComboBox ComboBox {
get { return comboBox; }
}

public PropertyComboBo xColumn( PropertyEditorT able pe )
{
this.pe = pe;
this.cm = null;
this.comboBox = new ComboBox();
this.comboBox.D ropDownStyle = ComboBoxStyle.D ropDown;
this.comboBox.L eave += new EventHandler( comboBox_Leave );
}

protected override void Edit (
CurrencyManager source,
int rowNum,
Rectangle bounds,
bool readOnly,
string instantText,
bool cellIsVisible )
{
base.Edit( source, rowNum, bounds, readOnly, instantText, cellIsVisible );

if( !readOnly && cellIsVisible )
{
iCurrentRow = rowNum;
cm = source;

DataGridTableSt yle.DataGrid.Sc roll += new EventHandler( DataGrid_Scroll );
comboBox.Parent = TextBox.Parent;
comboBox.Locati on =
DataGridTableSt yle.DataGrid.Ge tCurrentCellBou nds().Location;
comboBox.Size = new Size( TextBox.Size.Wi dth, comboBox.Size.H eight );

pe.SetDataSourc eForPropertyCom bo( rowNum, source, comboBox );

int foundIndex = comboBox.FindSt ringExact( TextBox.Text );
if( foundIndex == -1 )
comboBox.Text = TextBox.Text;
else
comboBox.Select edIndex = foundIndex;

comboBox.Show() ;
comboBox.BringT oFront();
comboBox.Focus( );
}
}

private void DataGrid_Scroll (object sender, EventArgs e)
{
comboBox.Hide() ;
}

private void comboBox_Leave( object sender, EventArgs e )
{
SetColumnValueA tRow( cm, iCurrentRow, comboBox.Text );
Invalidate();

comboBox.Hide() ;
DataGridTableSt yle.DataGrid.Sc roll -= new EventHandler( DataGrid_Scroll );
}
}

Thanks,
--
Tom Tempelaere.

[TT (Tom Tempelaere)]

Hi,

It appears that the Edit method is called twice when a user clicks on a
DataGrid: one time for the current cell, and then immediately for the newly
clicked cell. This results in comboBox_leave being called twice, and that
gives the exception when executing SetColumnValueA tRow.

I resolved this by comparing the iCurrentRow member and rowNum parameter, if
they're equal I do not do anything inside the Edit override.

TT.

"TT (Tom Tempelaere)" wrote:

Hay there,

I'm writing my own DataGridComboBo xColumn because .NET 1.1 does not have one
(I hope .NET 2.0 supplies one). I based it on this article:
http://msdn.microsoft.com/msdnmag/is...s/default.aspx

I have a problem when there are two DataGrid's on one form, and when I
switch focus from one grid to the other. To be more precise, when I'm editing
a combo box column in one grid, and then click in the combo column of another
grid an exception is thrown stating "The ListManager's position must be equal
to rowNum.
Parameter name: rowNum".

I will post the code if anyone feels like digging into it. Anyway, perhaps
someone has a better link with a how-to?

Notes about the code:
* The only thing that the PropertyEditorT able is used for in this context is
for setting the DataSource of the ComboBox that edits the value.
* The exception occurs when executing SetColumnValueA tRow in the
comboBox_Leave event handler

internal class PropertyComboBo xColumn : DataGridTextBox Column
{
protected PropertyEditorT able pe;
private ComboBox comboBox;
private CurrencyManager cm;
private int iCurrentRow;

public ComboBox ComboBox {
get { return comboBox; }
}

public PropertyComboBo xColumn( PropertyEditorT able pe )
{
this.pe = pe;
this.cm = null;
this.comboBox = new ComboBox();
this.comboBox.D ropDownStyle = ComboBoxStyle.D ropDown;
this.comboBox.L eave += new EventHandler( comboBox_Leave );
}

protected override void Edit (
CurrencyManager source,
int rowNum,
Rectangle bounds,
bool readOnly,
string instantText,
bool cellIsVisible )
{
base.Edit( source, rowNum, bounds, readOnly, instantText, cellIsVisible );

if( !readOnly && cellIsVisible )
{
iCurrentRow = rowNum;
cm = source;

DataGridTableSt yle.DataGrid.Sc roll += new EventHandler( DataGrid_Scroll );
comboBox.Parent = TextBox.Parent;
comboBox.Locati on =
DataGridTableSt yle.DataGrid.Ge tCurrentCellBou nds().Location;
comboBox.Size = new Size( TextBox.Size.Wi dth, comboBox.Size.H eight );

pe.SetDataSourc eForPropertyCom bo( rowNum, source, comboBox );

int foundIndex = comboBox.FindSt ringExact( TextBox.Text );
if( foundIndex == -1 )
comboBox.Text = TextBox.Text;
else
comboBox.Select edIndex = foundIndex;

comboBox.Show() ;
comboBox.BringT oFront();
comboBox.Focus( );
}
}

private void DataGrid_Scroll (object sender, EventArgs e)
{
comboBox.Hide() ;
}

private void comboBox_Leave( object sender, EventArgs e )
{
SetColumnValueA tRow( cm, iCurrentRow, comboBox.Text );
Invalidate();

comboBox.Hide() ;
DataGridTableSt yle.DataGrid.Sc roll -= new EventHandler( DataGrid_Scroll );
}
}

Thanks,
--
Tom Tempelaere.

[TT (Tom Tempelaere)]

Oops,

This gives other problems: When I do not change the current row in the grid
then I can't edit the value anymore ...

TT

"TT (Tom Tempelaere)" wrote:

Hi,

It appears that the Edit method is called twice when a user clicks on a
DataGrid: one time for the current cell, and then immediately for the newly
clicked cell. This results in comboBox_leave being called twice, and that
gives the exception when executing SetColumnValueA tRow.

I resolved this by comparing the iCurrentRow member and rowNum parameter, if
they're equal I do not do anything inside the Edit override.

TT.

"TT (Tom Tempelaere)" wrote:

Hay there,

I'm writing my own DataGridComboBo xColumn because .NET 1.1 does not have one
(I hope .NET 2.0 supplies one). I based it on this article:
http://msdn.microsoft.com/msdnmag/is...s/default.aspx

I have a problem when there are two DataGrid's on one form, and when I
switch focus from one grid to the other. To be more precise, when I'm editing
a combo box column in one grid, and then click in the combo column of another
grid an exception is thrown stating "The ListManager's position must be equal
to rowNum.
Parameter name: rowNum".

I will post the code if anyone feels like digging into it. Anyway, perhaps
someone has a better link with a how-to?

Notes about the code:
* The only thing that the PropertyEditorT able is used for in this context is
for setting the DataSource of the ComboBox that edits the value.
* The exception occurs when executing SetColumnValueA tRow in the
comboBox_Leave event handler

internal class PropertyComboBo xColumn : DataGridTextBox Column
{
protected PropertyEditorT able pe;
private ComboBox comboBox;
private CurrencyManager cm;
private int iCurrentRow;

public ComboBox ComboBox {
get { return comboBox; }
}

public PropertyComboBo xColumn( PropertyEditorT able pe )
{
this.pe = pe;
this.cm = null;
this.comboBox = new ComboBox();
this.comboBox.D ropDownStyle = ComboBoxStyle.D ropDown;
this.comboBox.L eave += new EventHandler( comboBox_Leave );
}

protected override void Edit (
CurrencyManager source,
int rowNum,
Rectangle bounds,
bool readOnly,
string instantText,
bool cellIsVisible )
{
base.Edit( source, rowNum, bounds, readOnly, instantText, cellIsVisible );

if( !readOnly && cellIsVisible )
{
iCurrentRow = rowNum;
cm = source;

DataGridTableSt yle.DataGrid.Sc roll += new EventHandler( DataGrid_Scroll );
comboBox.Parent = TextBox.Parent;
comboBox.Locati on =
DataGridTableSt yle.DataGrid.Ge tCurrentCellBou nds().Location;
comboBox.Size = new Size( TextBox.Size.Wi dth, comboBox.Size.H eight );

pe.SetDataSourc eForPropertyCom bo( rowNum, source, comboBox );

int foundIndex = comboBox.FindSt ringExact( TextBox.Text );
if( foundIndex == -1 )
comboBox.Text = TextBox.Text;
else
comboBox.Select edIndex = foundIndex;

comboBox.Show() ;
comboBox.BringT oFront();
comboBox.Focus( );
}
}

private void DataGrid_Scroll (object sender, EventArgs e)
{
comboBox.Hide() ;
}

private void comboBox_Leave( object sender, EventArgs e )
{
SetColumnValueA tRow( cm, iCurrentRow, comboBox.Text );
Invalidate();

comboBox.Hide() ;
DataGridTableSt yle.DataGrid.Sc roll -= new EventHandler( DataGrid_Scroll );
}
}

Thanks,
--
Tom Tempelaere.

[TT (Tom Tempelaere)]

Hi,

This solution seems to do better. Change the comboBox_leave handler to:

private void comboBox_Leave( object sender, EventArgs e )
{
if( cm.Position == iCurrentRow )
SetColumnValueA tRow( cm, iCurrentRow, comboBox.Text );
Invalidate();
comboBox.Hide() ;
DataGridTableSt yle.DataGrid.Sc roll -= new EventHandler( DataGrid_Scroll );
}

TT
"TT (Tom Tempelaere)" wrote:

Hay there,

I'm writing my own DataGridComboBo xColumn because .NET 1.1 does not have one
(I hope .NET 2.0 supplies one). I based it on this article:
http://msdn.microsoft.com/msdnmag/is...s/default.aspx

I have a problem when there are two DataGrid's on one form, and when I
switch focus from one grid to the other. To be more precise, when I'm editing
a combo box column in one grid, and then click in the combo column of another
grid an exception is thrown stating "The ListManager's position must be equal
to rowNum.
Parameter name: rowNum".

I will post the code if anyone feels like digging into it. Anyway, perhaps
someone has a better link with a how-to?

Notes about the code:
* The only thing that the PropertyEditorT able is used for in this context is
for setting the DataSource of the ComboBox that edits the value.
* The exception occurs when executing SetColumnValueA tRow in the
comboBox_Leave event handler

internal class PropertyComboBo xColumn : DataGridTextBox Column
{
protected PropertyEditorT able pe;
private ComboBox comboBox;
private CurrencyManager cm;
private int iCurrentRow;

public ComboBox ComboBox {
get { return comboBox; }
}

public PropertyComboBo xColumn( PropertyEditorT able pe )
{
this.pe = pe;
this.cm = null;
this.comboBox = new ComboBox();
this.comboBox.D ropDownStyle = ComboBoxStyle.D ropDown;
this.comboBox.L eave += new EventHandler( comboBox_Leave );
}

protected override void Edit (
CurrencyManager source,
int rowNum,
Rectangle bounds,
bool readOnly,
string instantText,
bool cellIsVisible )
{
base.Edit( source, rowNum, bounds, readOnly, instantText, cellIsVisible );

if( !readOnly && cellIsVisible )
{
iCurrentRow = rowNum;
cm = source;

DataGridTableSt yle.DataGrid.Sc roll += new EventHandler( DataGrid_Scroll );
comboBox.Parent = TextBox.Parent;
comboBox.Locati on =
DataGridTableSt yle.DataGrid.Ge tCurrentCellBou nds().Location;
comboBox.Size = new Size( TextBox.Size.Wi dth, comboBox.Size.H eight );

pe.SetDataSourc eForPropertyCom bo( rowNum, source, comboBox );

int foundIndex = comboBox.FindSt ringExact( TextBox.Text );
if( foundIndex == -1 )
comboBox.Text = TextBox.Text;
else
comboBox.Select edIndex = foundIndex;

comboBox.Show() ;
comboBox.BringT oFront();
comboBox.Focus( );
}
}

private void DataGrid_Scroll (object sender, EventArgs e)
{
comboBox.Hide() ;
}

private void comboBox_Leave( object sender, EventArgs e )
{
SetColumnValueA tRow( cm, iCurrentRow, comboBox.Text );
Invalidate();

comboBox.Hide() ;
DataGridTableSt yle.DataGrid.Sc roll -= new EventHandler( DataGrid_Scroll );
}
}

Thanks,
--
Tom Tempelaere.