// Methods private void InsertData() { // Select using (var command = new SqlCommandScope(_connectionString)) { // CommandParameters command.Parameters.Add(new SqlParameter("@Id", Guid.NewGuid().ToString())); command.Parameters.Add(new SqlParameter("@Name", Guid.NewGuid().ToString())); // CommandText command.CommandText = @"INSERT INTO Users (Id, Name) VALUES (@Id, @Name)"; // Execute command.ExecuteNonQuery(); } }
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; }