Populating a Silverlight DataGrid with Data from MDB

raelango

Rate me:

5.00/5 (11 votes)

24 Nov 2009CPOL2 min read

75.1K

2.3K

This is a sample project to access Microsoft Access MDB data in Silverlight via OLEDB and dynamically populate a DataGrid.

accesstodatagridinsilverlight.zip
- AccessToDataGridInSilverlight.Web
  - Access.svc
  - Access.svc.cs
  - AccessToDataGridInSilverlight.Web.csproj
  - AccessToDataGridInSilverlight.Web.csproj.user
  - AccessToDataGridInSilverlightTestPage.aspx
  - AccessToDataGridInSilverlightTestPage.html
  - App_Data
  - bin
    - AccessToDataGridInSilverlight.Web.dll
  - ClientBin
    - AccessToDataGridInSilverlight.xap
  - Default.aspx
  - Default.aspx.cs
  - Default.aspx.designer.cs
  - IAccess.cs
  - Properties
    - AssemblyInfo.cs
  - Silverlight.js
  - Web.config
- AccessToDataGridInSilverlight
  - AccessToDataGridInSilverlight.csproj
  - AccessToDataGridInSilverlight.csproj.user
  - AccessToDataGridInSilverlight.sln
  - AccessToDataGridInSilverlight.suo
  - App.xaml
  - App.xaml.cs
  - Bin
    - Debug
      - AccessToDataGridInSilverlight.dll
      - AccessToDataGridInSilverlight.pdb
      - AccessToDataGridInSilverlight.xap
      - AppManifest.xaml
      - de
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        System.Windows.Data.resources.dll
        
        System.Xml.Linq.resources.dll
      - es
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        System.Windows.Data.resources.dll
        
        System.Xml.Linq.resources.dll
      - fr
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        System.Windows.Data.resources.dll
        
        System.Xml.Linq.resources.dll
      - it
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        System.Windows.Data.resources.dll
        
        System.Xml.Linq.resources.dll
      - ja
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        System.Windows.Data.resources.dll
        
        System.Xml.Linq.resources.dll
      - ko
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        System.Windows.Data.resources.dll
        
        System.Xml.Linq.resources.dll
      - System.ComponentModel.DataAnnotations.dll
      - System.ComponentModel.DataAnnotations.xml
      - System.Windows.Controls.Data.dll
      - System.Windows.Controls.Data.Input.dll
      - System.Windows.Controls.Data.Input.xml
      - System.Windows.Controls.Data.xml
      - System.Windows.Data.dll
      - System.Windows.Data.xml
      - System.Windows.Ria.dll
      - System.Windows.Ria.xml
      - System.Xml.Linq.dll
      - System.Xml.Linq.xml
      - TestPage.html
      - zh-Hans
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        System.Windows.Data.resources.dll
        
        System.Xml.Linq.resources.dll
      - zh-Hant
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        System.Windows.Data.resources.dll
        
        System.Xml.Linq.resources.dll
  - Generated_Code
    - AccessToDataGridInSilverlight.Web.g.cs
  - MainPage.xaml
  - MainPage.xaml.cs
  - obj
    - Debug
      - AccessToDataGridInSilverlight.csproj.FileListAbsolute.txt
      - AccessToDataGridInSilverlight.dll
      - AccessToDataGridInSilverlight.g.resources
      - AccessToDataGridInSilverlight.pdb
      - App.g.cs
      - MainPage.g.cs
      - Refactor
      - ResolveAssemblyReference.cache
      - RiaFiles.txt
      - RiaRefs.txt
      - TempPE
        
        Service References.AccessDB.Reference.cs.dll
      - XapCacheFile.xml
  - Properties
    - AppManifest.xml
    - AssemblyInfo.cs
  - Service References
    - AccessDB
      - Access.disco
      - Access.wsdl
      - Access.xsd
      - Access1.xsd
      - configuration.svcinfo
      - configuration91.svcinfo
      - Reference.cs
      - Reference.svcmap
  - ServiceReferences.ClientConfig
  - XMLValueConvertor.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace AccessToDataGridInSilverlight.Web
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }
    }
}

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

raelango

Architect Atom8 IT Solutions (P) Ltd

India

I have been programming since 1991. I consider programming as my passion. I founded Atom8 IT Solutions (P) Ltd., in April 2009 and have been developing applications in Microsoft Technologies (mainly C#, Silverlight).

My specialization has been on the US healthcare domain (Medical Transcription, Patient Financial Services, EMRs).

Populating a Silverlight DataGrid with Data from MDB

License

Comments and Discussions