Hello,

I have fetched records in dataset and now i want to bind controls with the dataset but it shows "cannot convert DBNull to "" string"

How to check whether value is Null? WHether i have to check every row is DBNUll or there is any other option?

Thanks...
Narendra

u can check Null value in ur Select statement

SELECT IsNull(FieldName1,0), IsNull(FieldName2,' ') FROM TableName

i hope it will help

Ashu

As an alternative, you could create a function that always returns a valid string.
I have a function called GetDBString():

public static string GetDBString(object obj) {
    if(!(obj is DBNull)) {
        return (string)obj;
    }
    else {
        return string.Empty;
    }
}

-Peter

Hi,

I want all records with Primary key whether value is null or not and already filled a dataset with those records but now i want to use taht dataset to fill up the controls irrespective of Null value(If Null then "")...but while setting
like
txtrecNo.text = ds.tables(0)rows(0)(1)

it gives error if ds.tables(0)rows(0)(1) is null....

is there any check????

Thanks for reply....
Narendra

Are the answers above not enough?

The first answer outlines how to correct null values in the database.
The second provides a server function to handle it.

-Peter

Hi
 You can use txtrecNo.text = ds.tables(0)rows(0)(1).ToString()

tostring will convert null to blank string.

Thank U all....:)