newbie to .NET - Problem with DataGrid

[boogo]

Hello.
I have one main class, there is a datagrid with column headers:
"product","price","amount" and "net value".
My first question is how to make columns "price" and "net value" to be
a double type, simultaneously i want them shown as
currencies(something likes a currency format in Excel for example).
It's comfortable when i want to count an easy way "net
value"(amount*price) or sum of "net value"(value of order in this
case). I'd like to avoid notorious conversion(there are a lot:
inserting or removing new position, increase or decrease amount,
changing trade discounts etc.) from string to double and vice versa.
Second question is how to get rid of the grid lines in Excel Document
generated thanks to Microsoft Object Library. It's very easy to do it
in self Excel.

m_objExcel = new Excel.Application();
m_objExcel.Visible=true;
m_objBooks = (Excel.Workbooks)m_objExcel.Workbooks;
m_objBook = (Excel._Workbook)(m_objBooks.Add(m_objOpt));
m_objSheets = (Excel.Sheets)m_objBook.Worksheets;
....

I'm not able to find a right property in any of above-mentioned
references.

Thx)

 

[W.G. Ryan eMVP]

DataColumnName.DataType = Type.GetType("System.Double");
http://msdn.microsoft.com/library/d.../html/frlrfsystemdatadatacolumnclasstopic.asp
As far as formatting, use a DataGridTableStyle, then use a
DataGridColumnStyle
To format the fields, use this
http://msdn.microsoft.com/library/d...windowsformsdatagridcolumnstyleclasstopic.asp

You can check out this to help you as well
http://www.knowdotnet.com/articles/cgrid.html