Posts tagged: silverlight datagrid

Nov 02 2009

Display database data using Silverlight datagrid

First Refer to below link

how to create WCF service and LinqToSQL

Step1: First Create Silverlight Project in VS2008

Step2: In Page.xaml file Drag Silverlight Datagrid control

<data:DataGrid x:Name=”gridRegister“></data:DataGrid>

Step3: Add WCF Service (Register.svc) below link will explain

how to create WCF service and LinqToSQL view this link above

Then add Below OperationContract in Register.svc

Register.svc.cs

[OperationContract]

public IEnumerable<Registration> GetRegisterationList()

{

//SilverlightDataContext is from LinQ to SQL Classes

SilverlightDataContext db = new SilverlightDataContext();

return db.Registrations;

//Registrations is table name in Linq to sql classes

}

Page.Xaml.cs

using SilverlightDB.ServiceReference1; //add this namespace

namespace SilverlightDB

{

public partial class display : UserControl

{

public Page()

{

InitializeComponent();

//RegisterClient is explain in (how to create wcf and linq to sql classes)

RegisterClient client=new RegisterClient();

client.GetRegisterationListCompleted += new EventHandler<GetRegisterationListCompletedEventArgs>(client_GetRegisterationListCompleted);

client.GetRegisterationListAsync();

}

void client_GetRegisterationListCompleted(object sender, GetRegisterationListCompletedEventArgs e)

{

//gridRegister is name of Datagrid in Page.xaml

gridRegister.ItemsSource = e.Result;

}

}

}

Step4: Hit F5 to run the Application.

Alibi3col theme by Themocracy