How to close the datareader

this is a simple function that takes care of all the queries:

DataTable ReadIt(string query, params MySqlParameter[] sqlParams)
{
    DataTable dt = new DataTable();
 
    using(MySqlConnection myConnection = new MySqlConnection(sConnection))
    {
        myConnection.Open();
        MySqlCommand myCommand =myConnection.CreateCommand();
        myCommand.CommandText = query;
        foreach (var p in sqlParams)
        {
            myCommand.Parameters.Add(p);
        }
        MySqlDataReader myReader =myCommand.ExecuteReader(CommandBehavior.CloseConnection);
        dt.Load(myReader);
        myReader.Close();
    }
 
    return dt;
}

I want to myReader.Close(); afeter loading data to datatable

using (MySqlConnection myConnection = new MySqlConnection(sConnection))
        using (MySqlCommand myCommand = myConnection.CreateCommand())
        {
            myConnection.Open();
            myCommand.CommandText = query;
            foreach (var p in sqlParams)
                myCommand.Parameters.Add(p);
            using (MySqlDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection))
            {
                dt.Load(myReader);
            }
        }

forum

How to close the datareader

Manoj Bhatt

1 Answers

Liked By