Format grid column to display "" instead of datetime DBNull (1/1/1

[Carlos Lozano]

Hello Folks!

I have a grid that populates from a table on SQL Server. All datetime with
DBNull value show 1/1/1900 12:00AM ... Instead of just blank ("").

I found a document with the following code, but didn't work.

public void setGridColumnSt yle()
{
DataGridColumnS tyle newColStyle;
newColStyle = oGrid.TableStyl es[0].GridColumnStyl es[0];
newColStyle.Nul lText = "";
}

I tried to customize it to my needs as below:
public void setGridColumnSt yle(ref System.Windows. Forms.Grid oGrid, string
sTable, string sColumn)
{
DataGridColumnS tyle newColStyle;
newColStyle = oGrid.TableStyl es[sTable].GridColumnStyl es[sColumn];
newColStyle.Nul lText = "";
}

I always got an error on second line.

I will appreciate any help to do this.

Carlos Lozano
www.caxonline.net

[Chris]

Carlos Lozano wrote:

Hello Folks!

I have a grid that populates from a table on SQL Server. All datetime with
DBNull value show 1/1/1900 12:00AM ... Instead of just blank ("").

I found a document with the following code, but didn't work.

public void setGridColumnSt yle()
{
DataGridColumnS tyle newColStyle;
newColStyle = oGrid.TableStyl es[0].GridColumnStyl es[0];
newColStyle.Nul lText = "";
}

I tried to customize it to my needs as below:
public void setGridColumnSt yle(ref System.Windows. Forms.Grid oGrid, string
sTable, string sColumn)
{
DataGridColumnS tyle newColStyle;
newColStyle = oGrid.TableStyl es[sTable].GridColumnStyl es[sColumn];
newColStyle.Nul lText = "";
}

I always got an error on second line.

I will appreciate any help to do this.

Carlos Lozano
www.caxonline.net

What is the error? Is the error at runtime or design time...

Chris

[Carlos Lozano]

Hi Chris,

The error is at runtime. It says "object not set to an instance". I know
the grid is not the problem as I can see it after it is populated.
I think it refers to the TableStyles object within the Grid. I Added the
following line to verify:

int nStyles = oGrid.TableStyl es.Count;

nStyles value is zero. I was expecting a value of 1 as the grid was
populated from a table.

Just in case you are wondering, the column formatting setGridColumnSt yle()
is called after the grid is populated.

Any Ideas?

Thank you,

Carlos Lozano

"Chris" wrote:

Carlos Lozano wrote:

Hello Folks!

I have a grid that populates from a table on SQL Server. All datetime with
DBNull value show 1/1/1900 12:00AM ... Instead of just blank ("").

I found a document with the following code, but didn't work.

public void setGridColumnSt yle()
{
DataGridColumnS tyle newColStyle;
newColStyle = oGrid.TableStyl es[0].GridColumnStyl es[0];
newColStyle.Nul lText = "";
}

I tried to customize it to my needs as below:
public void setGridColumnSt yle(ref System.Windows. Forms.Grid oGrid, string
sTable, string sColumn)
{
DataGridColumnS tyle newColStyle;
newColStyle = oGrid.TableStyl es[sTable].GridColumnStyl es[sColumn];
newColStyle.Nul lText = "";
}

I always got an error on second line.

I will appreciate any help to do this.

Carlos Lozano
www.caxonline.net

What is the error? Is the error at runtime or design time...

Chris

[Chris]

Carlos Lozano wrote:

Hi Chris,

The error is at runtime. It says "object not set to an instance". I know
the grid is not the problem as I can see it after it is populated.
I think it refers to the TableStyles object within the Grid. I Added the
following line to verify:

int nStyles = oGrid.TableStyl es.Count;

nStyles value is zero. I was expecting a value of 1 as the grid was
populated from a table.

Just in case you are wondering, the column formatting setGridColumnSt yle()
is called after the grid is populated.

Any Ideas?

Thank you,

Carlos Lozano

"Chris" wrote:

Carlos Lozano wrote:

Hello Folks!

I have a grid that populates from a table on SQL Server. All datetime with
DBNull value show 1/1/1900 12:00AM ... Instead of just blank ("").

I found a document with the following code, but didn't work.

public void setGridColumnSt yle()
{
DataGridColumnS tyle newColStyle;
newColStyle = oGrid.TableStyl es[0].GridColumnStyl es[0];
newColStyle.Nul lText = "";
}

I tried to customize it to my needs as below:
public void setGridColumnSt yle(ref System.Windows. Forms.Grid oGrid, string
sTable, string sColumn)
{
DataGridColumnS tyle newColStyle;
newColStyle = oGrid.TableStyl es[sTable].GridColumnStyl es[sColumn];
newColStyle.Nul lText = "";
}

I always got an error on second line.

I will appreciate any help to do this.

Carlos Lozano
www.caxonline.net

What is the error? Is the error at runtime or design time...

Chris

If newColStyle = oGrid.TableStyl es[0].GridColumnStyl es[0]; works and
newColStyle returns something and
oGrid.TableStyl es[sTable].GridColumnStyl es[sColumn]; returns nothing
then the names you are passing in for either sTable or sColumn is
returning nothing. Most likely sTable is the issue.

obj Object = oGrid.TableStyl es[sTable];

Run that line of code and see if obj is set to null; if it does it
means that name of your tablestyle isn't equal sTable.

oGrid.TableStyl es[0].TableName ??? there is some method that will give
you the name of your tablesytle, I don't know what it is called off the
top of my head.

hope it helps.
Chris

[Carlos Lozano]

Hi Chris,

I just found where the problem is. The Grid does not have a tableStyles.
Grid.TableStyle s.Count = 0 after creating the grid.
I added a TableStyle before populating it from a Table and i can handle the
grid's column properties (width, etc).

What I am still having trouble with isdatetime fields with dbNull values
still display as 1/1/1900 even when the ColumnStyle.Nul lText = "".

Thank you for your help.

Carlos Lozano
www.caxonline.net

"Chris" wrote:

Carlos Lozano wrote:

Hi Chris,

The error is at runtime. It says "object not set to an instance". I know
the grid is not the problem as I can see it after it is populated.
I think it refers to the TableStyles object within the Grid. I Added the
following line to verify:

int nStyles = oGrid.TableStyl es.Count;

nStyles value is zero. I was expecting a value of 1 as the grid was
populated from a table.

Just in case you are wondering, the column formatting setGridColumnSt yle()
is called after the grid is populated.

Any Ideas?

Thank you,

Carlos Lozano

"Chris" wrote:

Carlos Lozano wrote:

Hello Folks!

I have a grid that populates from a table on SQL Server. All datetime with
DBNull value show 1/1/1900 12:00AM ... Instead of just blank ("").

I found a document with the following code, but didn't work.

public void setGridColumnSt yle()
{
DataGridColumnS tyle newColStyle;
newColStyle = oGrid.TableStyl es[0].GridColumnStyl es[0];
newColStyle.Nul lText = "";
}

I tried to customize it to my needs as below:
public void setGridColumnSt yle(ref System.Windows. Forms.Grid oGrid, string
sTable, string sColumn)
{
DataGridColumnS tyle newColStyle;
newColStyle = oGrid.TableStyl es[sTable].GridColumnStyl es[sColumn];
newColStyle.Nul lText = "";
}

I always got an error on second line.

I will appreciate any help to do this.

Carlos Lozano
www.caxonline.net
What is the error? Is the error at runtime or design time...

Chris

If newColStyle = oGrid.TableStyl es[0].GridColumnStyl es[0]; works and
newColStyle returns something and
oGrid.TableStyl es[sTable].GridColumnStyl es[sColumn]; returns nothing
then the names you are passing in for either sTable or sColumn is
returning nothing. Most likely sTable is the issue.

obj Object = oGrid.TableStyl es[sTable];

Run that line of code and see if obj is set to null; if it does it
means that name of your tablestyle isn't equal sTable.

oGrid.TableStyl es[0].TableName ??? there is some method that will give
you the name of your tablesytle, I don't know what it is called off the
top of my head.

hope it helps.
Chris