private void rep1()
        {
            string connect = "Data Source=.\\sd567;Initial Catalog=Northwind;Integrated Security=True";
            string query = "SELECT employeeid, firstname, lastname FROM employees";
            using (SqlConnection conn = new SqlConnection(connect))
            {
                using (SqlCommand command = new SqlCommand(query, conn))
                {
                    command.Connection.Open();
                    using (SqlDataReader reader = command.ExecuteReader())
                    {
                        while (reader.Read()) // <---------
                        {
                            Repeater1.DataSource = reader;
                            Repeater1.DataBind();
                        }

                    }

                }
            }
        }