[altarek]

i have a question in invalid operation exception. it says that " ExecuteReader Connection is closed and must be open

PHP Code:

SqlConnection conn = new SqlConnection("Server=localhost\\SqlExpress;" +

"Database=db;Integrated Security=True");

            SqlCommand comm = new SqlCommand("SELECT EmpID, Name FROM Employee", conn);

           

            SqlDataReader reader = comm.ExecuteReader(); 

[altarek]

ok,the problem solved

add this line before reader

comm.Connection.Open();

PHP Code:

SqlConnection conn = new SqlConnection("Server=localhost\\SqlExpress;" + 

"Database=db;Integrated Security=True"); 

            SqlCommand comm = new SqlCommand("SELECT EmpID, Name FROM Employee", conn); 

            comm.Connection.Open(); 

            SqlDataReader reader = comm.ExecuteReader(); 

[digioz]

Yes. You always have to open a database connection before reading from it.

Here is the official Microsoft recommended way of doing it:

Code:

private static void ReadData(string connectionString, string sql)
{
    string queryString = sql;

    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        SqlCommand command = new SqlCommand(queryString, connection);
        connection.Open();

        SqlDataReader reader = command.ExecuteReader();

        // Call Read before accessing data.
        while (reader.Read())
        {
            Console.WriteLine(String.Format("{0}, {1}", reader[0], reader[1]));
        }

        // Call Close when done reading.
        reader.Close();
    }
}