Format of DataGridView value

Posted by Vadim on Stack Overflow See other posts from Stack Overflow or by Vadim
Published on 2010-03-17T10:59:02Z Indexed on 2010/03/17 11:01 UTC
Read the original article Hit count: 204

Filed under:

vb.net

|

datagridview

|

winforms

I have a DataGridView which is filling from Table in SQL Server Database. One of it's columns is "price".

Type of column in DGV is automatically sets as Decimal.

In some cases I need to write in cells of this column text like "none", instead of price.

How can I do it?

DGV.Item("price", 0).Value = "none" doesn't work, because of decimal type of a cell.

© Stack Overflow or respective owner

Related posts about vb.net

VB.NET How Do I skin a vb.net app

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to skin a vb.net app I made ive googled some stuff and I've seen skinned vb.net apps. However it seems like any time i try to find someone explaining it its a link to a pay for product. Does anyone have anything useful on this? >>> More
VB.NET IF() Coalesce and “Expression Expected” Error

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
I am trying to use the equivalent of the C# “??” operator in some VB.NET code that I am working in. This StackOverflow article for “Is there a VB.NET equivalent for C#'s ?? operator?” explains the VB.NET IF() statement syntax which is exactly what I am looking for... and I thought I was going to… >>> More
Would a programmer knowing C# and VB.Net ever choose VB.Net?

as seen on Programmers - Search for 'Programmers'
Now before someone tells me VB.Net isn't bad like VB was, I know it isn't. But, I've yet to speak to a programmer who is completely content that some project they work on is written in VB.Net. Basically, my question is would a programmer knowing both C# and VB.Net (and all of their team knowing both)… >>> More
Do I lose anything by coding in c# and using free online vb.net code convertors?

as seen on Programmers - Search for 'Programmers'
The company I work for uses vb.net since there are many programmers who moved up from vb6 to vb.net. Basically more vb.net resources in the company for support/maintenance vs c#. I am a c# coder and was wondering if I could just continue coding in c# and just use the many online free c# to vb.net… >>> More
What are some good/reputable/widely-used libraries written in VB.NET?

as seen on Stack Overflow - Search for 'Stack Overflow'
Generally speaking, when VB.NET and C# are compared, there is a lot of strong support for C#, accompanied by some bashing of VB.NET until a respected developer comes along and acts as The Voice Of Reason, pointing out that while VB prior to VB.NET had its fair share of issues, VB.NET is really a very… >>> More

Related posts about datagridview

DataGridView.CellValueChanged not firing on bound DataGridView

as seen on Stack Overflow - Search for 'Stack Overflow'
When I change a value programatically in a DataTable that my DataGridView is bound to, the appropriate CellValueChanged event is not firing for the DataGridView. I'm trying to change a cell's background color based on cell value when the DataTable is filled with data without iterating through every… >>> More
PowerShell dataGridView - Copy only one Row into an other dataGridView

as seen on Stack Overflow - Search for 'Stack Overflow'
I´ve got a very short question about the "dataGridView". I´m developing with the Microsoft PowerShell and I want to copy one Row (from $dataGridView1) to the other ($dataGridView2). With this Code I can only Copy the Value of the last focused Cell. I´ve tried to make this for a whole Row, but it´s… >>> More
fill combobox value in datagridview based on other combobox in datagridview

as seen on Stack Overflow - Search for 'Stack Overflow'
I m creating Web Application..in C# I have One Data grid view In that i Have 2 Combo box i m trying 2 bind second combo box based on first combo-box. in First Combo-box I have value Shirt,T shirt so i want if shirt is selected than second combo-box should have value Slim,Regular..and if T shirt Is… >>> More
how to create datagridview dynamically in c#?

as seen on Stack Overflow - Search for 'Stack Overflow'
how to create datagridview dynamically in c#? >>> More
How to Edit rows in DataGridView?

as seen on Stack Overflow - Search for 'Stack Overflow'
So I've a button on my frmMain that opens up another frmEdit which has a datagridview that displays the following query: BindingSource bs = new BindingSource(); string sqlqry = "select p_Name from Items where p_Id=" + p_Id; SqlCeCommand cmd = new SqlCeCommand(sqlqry1, conn); SqlCeDataReader rdr… >>> More