Unable to cast object of type System.DBNull to type System.String [duplicate]

Question

In my database I have 6 columns, all of them allow null values. I want to make a simple form with an updating feature.

Product , SNO ,BTCH Expiry ,QTY ,RATE and Amount.

I get an exception:

Unable to cast object of type 'System.DBNull' to type 'System.String'

Here is my code :

int a = dataGridView1.CurrentCell.RowIndex;

            try
            {

                using (AmdDataSet.Test_ibrahimDataTable table = new AmdDataSet.Test_ibrahimDataTable())
                {

                  int b = a+1;
                    using (AmdDataSetTableAdapters.Test_ibrahimTableAdapter adp = new AmdDataSetTableAdapters.Test_ibrahimTableAdapter())
                    {
                        adp.GetDataBySNO(a);
                         AmdDataSet.Test_ibrahimRow erow;
                        erow = table.NewTest_ibrahimRow();
                        lblSNO.Text = erow.SNO.ToString();
                        txtProduct.Text= erow.PRODUCTS;
                        txtExpiry.Text = erow.EXPIRYDATE.ToShortDateString();
                        txtBatchNo.Text = erow.BATCHNO.Trim().ToString();

                    }
                }
            }
            catch (Exception ex)
            {
                lbleror.Text = ex.Message;
            }

Blachshma · Accepted Answer · 2012-05-17 07:55:23Z

5

Try this

lblSNO.Text = (erow.SNO == null) ? string.Empty : erow.SNO.ToString()

or

lblSNO.Text = (erow.SNO == DBNull.Value) ? string.Empty : erow.SNO.ToString()

answered May 17, 2012 at 7:55

Blachshma

17.5k4 gold badges62 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Emad Mokhtar Over a year ago

Actually the second option will work

ebbicsku Over a year ago

lblSNO.Text = (erow.SNO == DBNull.Value) ? string.Empty : erow.SNO.ToString() it is Showing Cannot be applied of Type int

Blachshma Over a year ago

What is the type of SNO column in the DB?

Chuck D Over a year ago

These didn't work for me.. I had to use the Is[PropertyName]Null() method of the dataset property.

Marek Dzikiewicz · Accepted Answer · 2012-05-17 07:55:16Z

2

Before calling ToString method call Convert.IsDBNull to check if value is not null.

answered May 17, 2012 at 7:55

Marek Dzikiewicz

2,8841 gold badge24 silver badges24 bronze badges

Collectives™ on Stack Overflow

Unable to cast object of type System.DBNull to type System.String [duplicate]

2 Answers 2

4 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Linked

Related