Asp.net[vb] : Reading records with null values

[ak1dnar]

Hi all,

I am getting this error in my ASP.net App, when reading some records which contains Null values for some of the columns.

System.Data.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values. at System.Data.SqlTypes.SqlString.get_Value() at System.Data.SqlClient.SqlDataReader.GetString(Int32 i) at MyAPP.step_2.GetClinics(Object ThisSelectedLocation) in D:\asp_apps\MyAPP\CRS\Dir\step_2.aspx.vb:line 217 
 

So here is the sample Structure of the Sql Table:

ID - Name - code
2395 Some_name_goes_here NULL // Here THere is a Null Value
2396 Some_name_goes_here 56
2397 Some_name_goes_here 88
 

Here is the code:

What sould I do to prevent this error:
 
[/size]Do While (Result.Read())
txt_box1.Text = Result.GetString(0).ToString
txt_box2.Text = Result.GetString(1).ToStrin
txt_box3.Text = Result.GetString(2).ToString
Loop
 

How to prevent this error?
Thanks!

[prabunewindia]

hi friend,
try with one,
just put like this

txtBox.Text= Result(index).ToString()

try and reply
Prabu

Hi all,

I am getting this error in my ASP.net App, when reading some records which contains Null values for some of the columns.

System.Data.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values. at System.Data.SqlTypes.SqlString.get_Value() at System.Data.SqlClient.SqlDataReader.GetString(Int32 i) at MyAPP.step_2.GetClinics(Object ThisSelectedLocation) in D:\asp_apps\MyAPP\CRS\Dir\step_2.aspx.vb:line 217 
 

So here is the sample Structure of the Sql Table:

ID - Name - code
2395 Some_name_goes_here NULL // Here THere is a Null Value
2396 Some_name_goes_here 56
2397 Some_name_goes_here 88
 

Here is the code:

What sould I do to prevent this error:
 
[/size]Do While (Result.Read())
txt_box1.Text = Result.GetString(0).ToString
txt_box2.Text = Result.GetString(1).ToStrin
txt_box3.Text = Result.GetString(2).ToString
Loop
 

How to prevent this error?
Thanks!

[ak1dnar]

hi friend,
try with one,
just put like this

txtBox.Text= Result(index).ToString()

try and reply
Prabu

wow !
Hi prabunewindia,
It works like a charm. ! Thanks for your time.