troubleshooting Question

Creating a public property for a class in C#

Avatar of adamtrask
adamtrask asked on
.NET ProgrammingC#
4 Comments1 Solution423 ViewsLast Modified:
Hello experts,

I am trying to create a public property for a class named ListsDB

The purpose of this public property is to retrieve data from a table in a database

I believe the code is ok except for the  following line which generates an error message:

 myCallsList.Add (reader("Call"));

The error message simply says "reader" is a variable but is used like a method.

myCallsList is a strongly typed string List and I am quite at loss as to how to rewrite the line which generates the error.

Thanks



public void getAllCalls()
    {
        SqlConnection con = default(SqlConnection);
        SqlCommand comm = default(SqlCommand);
               con = new SqlConnection("Server=Tariq; Database=HelpDesk;Integrated Security=True");
        comm = new SqlCommand("Select * from Calls", con);
        con.Open();
            SqlDataReader reader = comm.ExecuteReader();
            while (reader.Read())
            {
              myCallsList.Add (reader("Call"));
            }
            reader.Close();
            con.Close();

        }
    }

Open in new window

ASKER CERTIFIED SOLUTION
starlite551

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros