Datagrid Custom table/column style...

[Darryn Ross]

Hi,

I am trying to display a long integer value from my access table in a
Datagrid with a custom style applied to it and the value is not coming
through correct??

database value = 0.00000 %
datagrid value = 0.00 %

How do i get my column style to display the details as they are in the
table???...

the columns in question are the % columns...

my code is as follows.....
string[] strHeaderText = new string[] {"Partner ID", "Partner Name",
"Current Year %", "Last Year %", "Two Years Ago %", "Three Years Ago %",
"Four Years Ago %"} ;

int[] iWidth = new int[] {70, 150, 95, 95, 95, 95, 95} ;

// Add a GridTableStyle and set the MappingName

// to the name of the DataTable.

DataGridTableStyle TSPartner = new DataGridTableStyle() ;

TSPartner.MappingName = "tblPartner" ;

DataTable dt = PartDs.Tables["tblPartner"] ;

// Add a GridColumnStyle and set the MappingName

// to the name of a DataColumn in the DataTable.

// Set the HeaderText and Width properties.

for(int i = 0; i < 7; i++) {

DataGridTextBoxColumn CColStyle = new DataGridTextBoxColumn() ;

CColStyle.MappingName = dt.Columns[i].ColumnName ;

CColStyle.HeaderText = strHeaderText[i] ;

CColStyle.Width = iWidth[i] ;

CColStyle.ReadOnly = (i == 0) ? true : false ;

if(i == 1) {

dt.Columns[i].DefaultValue = "" ;

}

else if(i > 1) {

dt.Columns[i].DefaultValue = 0 ;

CColStyle.Format = "P" ;

}

TSPartner.GridColumnStyles.Add(CColStyle) ;

CColStyle.Dispose() ;

}

TSPartner.AllowSorting = false ;

dgPartners.TableStyles.Add(TSPartner) ;

Regards

Darryn

[SerhaD Ýnanlý]

Not sure but try

CColStyle.Format = "##.#####";

Hopes This Helps
"Darryn Ross" <da****@datawave.com.au> wrote in message
news:#E**************@TK2MSFTNGP12.phx.gbl...

Hi,

I am trying to display a long integer value from my access table in a
Datagrid with a custom style applied to it and the value is not coming
through correct??

database value = 0.00000 %
datagrid value = 0.00 %

How do i get my column style to display the details as they are in the
table???...

the columns in question are the % columns...

my code is as follows.....
string[] strHeaderText = new string[] {"Partner ID", "Partner Name",
"Current Year %", "Last Year %", "Two Years Ago %", "Three Years Ago %",
"Four Years Ago %"} ;

int[] iWidth = new int[] {70, 150, 95, 95, 95, 95, 95} ;

// Add a GridTableStyle and set the MappingName

// to the name of the DataTable.

DataGridTableStyle TSPartner = new DataGridTableStyle() ;

TSPartner.MappingName = "tblPartner" ;

DataTable dt = PartDs.Tables["tblPartner"] ;

// Add a GridColumnStyle and set the MappingName

// to the name of a DataColumn in the DataTable.

// Set the HeaderText and Width properties.

for(int i = 0; i < 7; i++) {

DataGridTextBoxColumn CColStyle = new DataGridTextBoxColumn() ;

CColStyle.MappingName = dt.Columns[i].ColumnName ;

CColStyle.HeaderText = strHeaderText[i] ;

CColStyle.Width = iWidth[i] ;

CColStyle.ReadOnly = (i == 0) ? true : false ;

if(i == 1) {

dt.Columns[i].DefaultValue = "" ;

}

else if(i > 1) {

dt.Columns[i].DefaultValue = 0 ;

CColStyle.Format = "P" ;

}

TSPartner.GridColumnStyles.Add(CColStyle) ;

CColStyle.Dispose() ;

}

TSPartner.AllowSorting = false ;

dgPartners.TableStyles.Add(TSPartner) ;

Regards

Darryn