Databinding with OpenAccess

2 posts, 0 answers
  1. SuperXRAY
    SuperXRAY avatar
    82 posts
    Member since:
    Feb 2007

    Posted 07 Mar 2009 Link to this post

    Can someone post the code to Databind the WPF RadGrid with an OpenAccess DataProvider?

    I cannot get anything to work!
  2. Jordan
    Admin
    Jordan avatar
    123 posts

    Posted 10 Mar 2009 Link to this post

    Hi SuperXRAY,

    I attached a sample project.

    First, I generated a wizard Product class from NorthwindOA database with open access.
    Then, I added a reference to the RadGridView assemblies and created a DatabaseRepository class to handle with Open Access.
    public class DatabaseReporsitory : IDisposable 
        private IObjectScope scope; 
     
        public DatabaseReporsitory() 
        { 
            this.scope = ObjectScopeProvider1.GetNewObjectScope(); 
            this.scope.TransactionProperties.AutomaticBegin = true
        } 
     
        public List<Product> GetProducts() 
        { 
            var result = from p in this.scope.Extent<Product>() 
                         select p; 
     
            return result.ToList(); 
        } 
     
        public void DeleteProduct(Product product) 
        { 
            this.scope.Remove(product); 
        } 
     
        public void SaveChanges() 
        { 
            this.scope.Transaction.Commit(); 
        } 
     
        public void Dispose() 
        { 
            if (this.scope != null
            { 
                this.scope.Dispose(); 
                this.scope = null
            } 
        } 

    Below is shown how it works with RadGridView
    public class DatabaseReporsitory : IDisposable 
      private IObjectScope scope; 
     
      public DatabaseReporsitory() 
      { 
        this.scope = ObjectScopeProvider1.GetNewObjectScope(); 
        this.scope.TransactionProperties.AutomaticBegin = true
      } 
     
      public List<Product> GetProducts() 
      { 
        var result = from p in this.scope.Extent<Product>() 
                     select p; 
     
        return result.ToList(); 
      } 
     
      public void DeleteProduct(Product product) 
      { 
        this.scope.Remove(product); 
      } 
     
      public void SaveChanges() 
      { 
        this.scope.Transaction.Commit(); 
      } 
     
      public void Dispose() 
      { 
        if (this.scope != null
        { 
            this.scope.Dispose(); 
            this.scope = null
        } 
      } 

    Some other links that can help you:
    OpenAccess, WCF, and a RadGrid
    Insert, Update, Delete with OpenAccess and RadGridView for Silverlight

    Kind regards,
    Jordan
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
  3. UI for WPF is Visual Studio 2017 Ready
Back to Top