Avatar of adamtrask
adamtrask

asked on 

Creating a public property for a class in C#

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

.NET ProgrammingC#

Avatar of undefined
Last Comment
adamtrask

8/22/2022 - Mon