sqlconnection missing type or namespace reference

Question

I have a sql query that I want to use to get results from a database. When I try to open a sqlconnection, my code won't compile and I get an error asking if i am missing a using directive.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;


namespace HackOffice.Superadmin
{
    public partial class FoundUsBreakdown : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            grabData();
        }
        private void grabData()
        {
            string chartDataQuery = "select AccountType, COUNT(*) Entries from HackOffice.dbo.OnlineSignups group by AccountType";
            using (sqlconnection connection = new sqlconnection(connectionString));
        }
    }
}

I'm confused because I have all the same using directives on other pages and I am not getting the same error on those pages.

wow. you can tell im new. thanks! If you put as answer i will mark it. — onTheInternet
– onTheInternet, Commented Jul 9, 2015 at 17:54

Yuval Itzchakov · Accepted Answer · 2015-07-09 17:55:59Z

1

Class names are case sensitive in C#. You need SqlConnection, not sqlconnection.

Also, you're creating an empty using statement which will dispose the resource immediately. When you open a using block, you'll want to put all the code that uses the IDisposable resource inside the block:

using (SqlConnection connection = new SqlConnection(connectionString))
{
   // Code that uses SqlConnection goes inside the block.
}

answered Jul 9, 2015 at 17:55

Yuval Itzchakov

150k32 gold badges276 silver badges333 bronze badges

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

1 Comment

onTheInternet Over a year ago

solid answer. will accept when i can. also i did not realize that. Thank you!

Collectives™ on Stack Overflow

sqlconnection missing type or namespace reference

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