• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 261
  • Last Modified:

problem with the following code

I created the following class file:

public class DataAccess
      {
            public DataAccess()
            {
                  //
                  // TODO: Add constructor logic here
                  //
            }
            public static SqlDataReader GetDepartments()
            {
                  SqlConnection connection = new SqlConnection(connectionString);
                  SqlCommand command = new SqlCommand("GetTopNav", connection);
                  command.CommandType = CommandType.StoredProcedure;
                  connection.Open();
                  return command.ExecuteReader(CommandBehavior.CloseConnection);
            }
            private static string connectionString
            {
                  get
                  {
                        return ConfigurationSettings.AppSettings("ConnectionString");
                  }
            }
      }
}

I'm getting error on the following lines:

command.CommandType = CommandType.StoredProcedure;

return command.ExecuteReader(CommandBehavior.CloseConnection);

return ConfigurationSettings.AppSettings("ConnectionString");  //this references the connection string stored in the web.config file

Thanks for any help.
0
-Dman100-
Asked:
-Dman100-
1 Solution
 
athapaCEO / CTOCommented:
Add this to the top of the page.

using System.Data;
using System.Configuration;

These should be already there but if not make sure these are on the top too.
using System;
using System.Data.SqlClient;

Change this
  return ConfigurationSettings.AppSettings("ConnectionString");
to
   return ConfigurationSettings.AppSettings["ConnectionString"];

AT
0
 
-Dman100-Software ConsultantAuthor Commented:
Thank you AT,

That corrected the problem.  I appreciate your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now