Getting null string from SQL database

Question

I'm trying to pull data from sql database and assigning it to text boxes. But I get error when there is no data in column (null).

 string athleteId = Request.Cookies["LoggedInUser"].ToString();
             var athlete = AthleteDAL.GetAthleteByID(athleteId);
             if (athlete.AthleteFName != null)
             {
                TextBoxFirstName.Text = athlete.AthleteFName.ToString();}

I'm getting null point exception on if statement.

Rusheel Jain · Accepted Answer · 2015-02-01 23:42:46Z

2

you need to have this if (athlete!=null && athlete.AthleteFName != null)

because athlete may be null and trying to use it (athlete.AthleteFName) is an invalid operation

answered Feb 1, 2015 at 23:42

Rusheel Jain

8436 silver badges20 bronze badges

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

1 Comment

John D Over a year ago

Thanks, you solved my problem. I was getting null (athlete) from database because of some error in GetAthleteByID function. Now I fixed the function too. Thanks man!

Collectives™ on Stack Overflow

Getting null string from SQL database

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related