Replacing Nulls in database table

Hot Topic

Changing CheckBox Checked
Automated Data Entry/Retrieval from Remote Web Sites
Progress Bar
for() and foreach() with the "else" clause
Problem with winspool OpenPrinter DllImport in 2005
is it possible to bring machine on domain through a program?
How can i get the holidays from my outlook calendar???
Progress Bar
Localization
How to set a ConnectionString Setting at runtime?

Visual C#

Get ALL the forms into a collection
Trimming a path
Inserting my C# component class in a MFC Window…
combo box display tables
Variable doesn't increment
Word Automation -- what a bind!
Hi everybody ! Help me about Charset of Dataset.
Determine origin of function call while debugging
ReportViewer Control for C# Express Windows Forms
easy way to encode a string

Replacing Nulls in database table

Hello,
I experience the following problem: I have a data table in the database, which includes float and smalldatetime columns. These columns can accept nulls. However when I load the table to the application and fill it to datagrid I do not want the user to see that annoying word "null" in the table. I tried to replace it with empty string but it is impossible since the type of the field is double or datetime.
Does anybody know how to solve this problem

Thanks.

Answer this question

Replacing Nulls in database table

  • BatesManty

    You can set the DataGridColumnStyle.NullText to set the text that is displayed when the column contains a null reference.


    DataGridTableStyle style = DataGrid1.TableStyles["DataTable1"];
    style.NullText = String.Empty;

  • adam kromm

    Check with System.DBNull

    example:

    dtABNORMALFLAGS.Rows[row][col]==System.DBNull.Value.ToString(); << ---- put condition here..

    I hope this is your requirement...let me know if you are still getting the problem.

    Mahes

  • Replacing Nulls in database table
Answer this question