Object reference not set to an instance of an object. problem?

Question

1.50/5 (2 votes)

See more:

C#

scmd1.CommandText = "SELECT User_Comments FROM Add_Comment WHERE Id='" + Dbid + "'";

                    scmd1.Connection = conn2;

                    //sql datareader
                    SqlDataReader sqldread2 = scmd1.ExecuteReader();
                    UserComment.Text = (sqldread2["User_Comments"].ToString());

i have datatable for user comment?
there are multiple comments to a particular id...

so i want to get all the comments into textbox?

how can i get it?

this code gives me an error in my select query

saying
Object reference not set to an instance of an object.

Posted 26-Jul-13 15:26pm

promod madushan

Updated 26-Jul-13 15:51pm

PIEBALDconsult

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 26-Jul-13 21:40pm

In what line?
Where can we see that conn2 is not null, for example?
—SA

[no name] 26-Jul-13 21:41pm

And again, you have to call the Read method on a SqlDataReader before you can get any data out of it.

Sergey Alexandrovich Kryukov 26-Jul-13 21:43pm

Sure...
—SA

[no name] 26-Jul-13 21:48pm

Only the 6th time I have told him that.

Sergey Alexandrovich Kryukov 26-Jul-13 21:56pm

Sixth?! No kidding?! Maybe this is a call for the abuse report on the account, not just particular question, as it apparently does not take desired effect.
—SA

Sergey Alexandrovich Kryukov 26-Jul-13 21:58pm

Let me see... 4 abuse reports already... Hm. I guess, some posts were pretty irritating... :-)
—SA

PIEBALDconsult 26-Jul-13 21:58pm

I don't think that's appropriate.

Sergey Alexandrovich Kryukov 26-Jul-13 21:59pm

Well, don't want to argue, but 4 people already decided to act this way...
—SA

PIEBALDconsult 26-Jul-13 22:13pm

Four wrongs don't make a right.

Sergey Alexandrovich Kryukov 26-Jul-13 23:43pm

Sure...
—SA

Sergey Alexandrovich Kryukov 26-Jul-13 22:02pm

Look at this "solution": http://www.codeproject.com/Answers/616711/I-made-a-code-for-do-the-selection-in-one-table-an#answer4
First of all, OP self-accepted it, because it was in response to his own question. And SqlReader.Read is already there... Doh...
—SA

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

PIEBALDconsult · Answer 1 · 2013-07-26T15:44:00

0) Use a parameterized command
1) Don't use strings for IDs
2) Is the connection open?
3) Read from the reader in a loop
4) I assume the value (when you get one) is already a string, so don't use ToString
5) Append the values to the TextBox

6) Put the DataReader in a using statement (the command too, if you like)

Object reference not set to an instance of an object. problem?

1 solution

Solution 1

Add your solution here

Preview 0

Object reference not set to an instance of an object. problem?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us