| 
                                                                            
                                                                                positivepurchasing
                                                                            - 
                                                                                7/18/2012 10:47:07 AM
                                                                            
                                                                         
                                                                        RE:Transformation/Data in custom web part 
                                                                            I've done the following 
 TreeProvider treeProvider = new TreeProvider();
 
 DataSet dataSet = treeProvider.SelectNodes(
 CMSContext.CurrentSiteName,
 ContentPath,
 null,
 true,
 "custom.Test");
 
 foreach (DataRow dataRow in dataSet.Tables["custom.Test"].Rows)
 {
 // do stuff
 }
 
 Which is obviously messy. Is there a nicer way to do this?
 
 Basically all I'm asking is how do I retrieve data from the database?
 
 Please Help!
 
                                                                            
                                                                         
 
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                         |