C# Execute SqlDataReader missing variable?

Question

I basically copied the example from microsoft.com, but it seems that CommandType does not exist in the current context. The example does not show declaring it.

Thanks

string SQLstring = @"Server=DELLXPS\SQLEXPRESS;Database=SEIN;Integrated Security=true";
SqlConnection sqlConnection1 = new SqlConnection(SQLstring);
SqlCommand cmd = new SqlCommand();
SqlDataReader reader;

cmd.CommandText = "SELECT * FROM ResidentUsers";
cmd.CommandType = CommandType.Text;
cmd.Connection = sqlConnection1;

sqlConnection1.Open();

reader = cmd.ExecuteReader();
// Data is accessible through the DataReader object here.

sqlConnection1.Close();

You need a using directive for its namespace.

SLaks
– SLaks

2016-10-26 17:26:43 +00:00
Commented Oct 26, 2016 at 17:26 — SLaks
– SLaks, Commented Oct 26, 2016 at 17:26

Rajput · Accepted Answer · 2016-10-26 18:09:10Z

1

you are missing some namespace try to add

using System.Data;

answered Oct 26, 2016 at 18:09

Rajput

2,60718 silver badges29 bronze badges

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

Comments

Paul Tsai · Accepted Answer · 2016-10-26 18:18:39Z

1

The using the keyword should be used around the connection, command, and datareader. This will ensure that even in the event of an exception occurring, the resources related to those items are released and connections are closed.

using System.Data.SqlClient;
using System.Data;

string SQLstring = @"Server=DELLXPS\SQLEXPRESS;Database=SEIN;IntegratedSecurity=true";
string commandText = "SELECT * FROM ResidentUsers";
using (var sqlConnection1 = new SqlConnection(SQLstring))
using (var cmd = new SqlCommand(commandText, sqlConnection1) { CommandType = CommandType.Text })
{
    sqlConnection1.Open();
    using (var reader = cmd.ExecuteReader())
    {
        // Data is accessible through the DataReader object here.
    }
    sqlConnection1.Close();
}

edited Oct 26, 2016 at 18:18

answered Oct 26, 2016 at 18:00

Paul Tsai

9136 silver badges16 bronze badges

Collectives™ on Stack Overflow

C# Execute SqlDataReader missing variable?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related