C#

Member 4211040 wrote:

I agree with you, it sound like something happens to the buffer that it becomes no longer valid but I am not sure what happens exactly!.

SELECT * FROM MyTable WHERE MyDateColumn BETWEEN '2014-01-01' AND '2014-01-31'

OriginalGriff wrote:

SELECT * WHERE MyDateColumn BETWEEN '2014-01-01' AND '2014-01-31'

using (SqlConnection con = new SqlConnection(strConnect))
    {
    con.Open();
    using (SqlCommand cmd = new SqlCommand("SELECT iD, description FROM myTable WHERE enterDate BETWEEN @FD AND @TD", con))
        {
        cmd.Parameters.AddWithValue("@FD", fromDatePicker.Value);
        cmd.Parameters.AddWithValue("@TD", toDatePicker.Value);
        using (SqlDataReader reader = cmd.ExecuteReader())
            {
            while (reader.Read())
                {
                int id = (int) reader["iD"];
                string desc = (string) reader["description"];
                Console.WriteLine("ID: {0}\n    {1}", iD, desc);
                }
            }
        }
    }