Example #1
0
        private void RefreshData()
        {
            // Result
            DataTable dataTable = new DataTable();

            // Select
            using (var command = new SqlCommandScope(_connectionString))
            {
                // CommandText
                command.CommandText = @"SELECT Id, Name FROM Users";

                // Create
                using (SqlDataReader reader = command.ExecuteReader())
                {
                    dataTable.Load(reader);
                }
            }

            // Display
            this.DisplayGridView.DataSource = dataTable;
        }