private void loadSold()
        {
            DataTable data = getService.getProductWithFilter("#sold", "CONVERT(VARCHAR(10), s.created_date, 111) BETWEEN  '" + range.from.Date.ToString("yyyy/MM/dd") + "' AND '" + range.to.Date.ToString("yyyy/MM/dd") + "'");

            if (data.Rows.Count > 0)
            {
                soldGridView.DataSource = data;
            }
        }