Conversion from type DBNull to type String is not valid VB.Net

baijuep

SOLVED CLOSED ACTIVE ANSWERED
User: baijuep
Posted: on Jul 26, 2013 08:40 PM
Forum: SQL Server
Answer: 1
Views: 4868

186 Points

470 Posts

Display data from database to a textbox

a few seconds ago|LINK

in a search page in my asp.net+vb web page. iam using a code as under but when the field is balnk it gives error.

statustxt.Text = dt.Tables("PERS").Rows(0).Item("OutDetails")

Then i tried this code also

If dt.Tables("PERS").Rows(0).Item("Courser") Is System.DBNull.Value <> True Then statustxt.Text = dt.Tables("PERS").Rows(0).Item("OutDetails") Else statustxt.Text = "" End If

but it also gives error as

Conversion from type 'DBNull' to type 'String' is not valid.

Download FREE API for Word, Excel and PDF in ASP.Net

RkHirpar...

0 3

Reply
ANSWER
User: RkHirpara
Replied: on Jul 26, 2013 11:06 PM
Report

Hi Baijuep,

Please be care full you are checking for "Courser" field and accessing value of "OutDetails" field, checking and access should be of same variable.

Thanks and Regards,

Rk_Hirpara

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Conversion from type DBNull to type String is not valid VB.Net

Display data from database to a textbox

Conversion from type 'DBNull' to type 'String' is not valid.

Company

Explore

Follow us

Contact Us