How do I set the datagrid column to currency format?

[Mike L]

Data in datagrid shows all numbers to the 1000th place. So, $3.00 is shown
3.0000

How do I set the datagrid column to currency format?

DataGridColumnS tyle colStyle4 = new
DataGridTextBox Column();
dgts.GridColumn Styles.Add(colS tyle4);
dgts.GridColumn Styles[4].Width = 75;
colStyle4.Mappi ngName = dt.Columns[4].ColumnName;

[Jeffrey Tan[MSFT]]

Hi Cadel,

Thanks for your post.

We can set DataGridTextBox Column.Format to "c" to get the currency format.
For more information, please refer to DataGridTextBox Column.Format in MSDN
documentation.

Hope this helps

Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

[Mike L]

The example shows connecting to a table, but I'm connecting to a SP.

I get the error, "Object reference not set to an instance of an object."

DataGridColumnS tyle colStyle4 = new
DataGridTextBox Column();
dgts.GridColumn Styles.Add(colS tyle4);
dgts.GridColumn Styles[4].Width = 75;
DataGridTextBox Column myGridTextBoxCo lumn =
(DataGridTextBo xColumn)dgPrivi leges.TableStyl es["dbo.SALES_REVE NUE"].GridColumnStyl es["GROSS_FEE_AMOU NT"];
myGridTextBoxCo lumn.Format = "c";
colStyle4.Mappi ngName = dt.Columns[4].ColumnName;

I have also tried using dt.TableName but recieved error, "Cannot convert
type 'string' to 'System.Windows .Forms.DataGrid TextBoxColumn'

DataGridTextBox Column myGridTextBoxCo lumn =
(DataGridTextBo xColumn)dt.Tabl eName;

""Jeffrey Tan[MSFT]"" wrote:

Hi Cadel,

Thanks for your post.

We can set DataGridTextBox Column.Format to "c" to get the currency format.
For more information, please refer to DataGridTextBox Column.Format in MSDN
documentation.

Hope this helps

Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

[Jeffrey Tan[MSFT]]

Hi Cadel,

Thanks for your feedback.

I think you may have some misunderstandin g of winform databinding. DataGrid
will have no relation to do with database, it only can be bound to .Net
data object, such as DataTable, DataSet, ArrayList etc.... So it does not
care whether the data comes from SP or a SQL statement.

Normally, at DataGrid formatting side, you should first correctly get the
DataGridTextBox Column reference. The exception you got is
NullReferenceEx ception, so I think myGridTextBoxCo lumn you got must be a
Null reference, which caused the problem, so please check this to ensure
that it gets the correct DataGridTextBox Column valid reference.

Thanks

Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.