Populating a Silverlight DataGrid with Data from MDB

raelango

Rate me:

5.00/5 (11 votes)

24 Nov 2009CPOL2 min read

75.9K

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

<?xml version="1.0" encoding="utf-8"?>
<xs:schema xmlns:tns="http://schemas.microsoft.com/2003/10/Serialization/" attributeFormDefault="qualified" elementFormDefault="qualified" targetNamespace="http://schemas.microsoft.com/2003/10/Serialization/" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:element name="anyType" nillable="true" type="xs:anyType" />
  <xs:element name="anyURI" nillable="true" type="xs:anyURI" />
  <xs:element name="base64Binary" nillable="true" type="xs:base64Binary" />
  <xs:element name="boolean" nillable="true" type="xs:boolean" />
  <xs:element name="byte" nillable="true" type="xs:byte" />
  <xs:element name="dateTime" nillable="true" type="xs:dateTime" />
  <xs:element name="decimal" nillable="true" type="xs:decimal" />
  <xs:element name="double" nillable="true" type="xs:double" />
  <xs:element name="float" nillable="true" type="xs:float" />
  <xs:element name="int" nillable="true" type="xs:int" />
  <xs:element name="long" nillable="true" type="xs:long" />
  <xs:element name="QName" nillable="true" type="xs:QName" />
  <xs:element name="short" nillable="true" type="xs:short" />
  <xs:element name="string" nillable="true" type="xs:string" />
  <xs:element name="unsignedByte" nillable="true" type="xs:unsignedByte" />
  <xs:element name="unsignedInt" nillable="true" type="xs:unsignedInt" />
  <xs:element name="unsignedLong" nillable="true" type="xs:unsignedLong" />
  <xs:element name="unsignedShort" nillable="true" type="xs:unsignedShort" />
  <xs:element name="char" nillable="true" type="tns:char" />
  <xs:simpleType name="char">
    <xs:restriction base="xs:int" />
  </xs:simpleType>
  <xs:element name="duration" nillable="true" type="tns:duration" />
  <xs:simpleType name="duration">
    <xs:restriction base="xs:duration">
      <xs:pattern value="\-?P(\d*D)?(T(\d*H)?(\d*M)?(\d*(\.\d*)?S)?)?" />
      <xs:minInclusive value="-P10675199DT2H48M5.4775808S" />
      <xs:maxInclusive value="P10675199DT2H48M5.4775807S" />
    </xs:restriction>
  </xs:simpleType>
  <xs:element name="guid" nillable="true" type="tns:guid" />
  <xs:simpleType name="guid">
    <xs:restriction base="xs:string">
      <xs:pattern value="[\da-fA-F]{8}-[\da-fA-F]{4}-[\da-fA-F]{4}-[\da-fA-F]{4}-[\da-fA-F]{12}" />
    </xs:restriction>
  </xs:simpleType>
  <xs:attribute name="FactoryType" type="xs:QName" />
  <xs:attribute name="Id" type="xs:ID" />
  <xs:attribute name="Ref" type="xs:IDREF" />
</xs:schema>

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