This is a migrated thread and some comments may be shown as answers.

[Solved] Connecting MSSQL 2005/2008 via WCF

11 Answers 149 Views
GridView
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Gopal
Top achievements
Rank 1
Gopal asked on 08 Dec 2009, 04:27 AM
Hi there,
  I have to connect a table via wcf  with RadGridView. I have tried the tutorial but unable to do so.
 So my request is pls can you give any link or working example so i can proceed. 
 Thank Q in advance !!!!

11 Answers, 1 is accepted

Sort by
0
Vlad
Telerik team
answered on 08 Dec 2009, 07:04 AM
Hi Gopal,

 The easiest way is WCF RIA services (formerly RIA Services) or WCF Data Services (formerly ADO.NET Data Services).

Kind regards,
Vlad
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
0
Gopal
Top achievements
Rank 1
answered on 08 Dec 2009, 07:08 AM
Thank Q very much.
Would you please show me or link me to a working example of it.

0
Vlad
Telerik team
answered on 08 Dec 2009, 07:17 AM
Hello,

Working examples can be found in our online demos:

RIA services: http://demos.telerik.com/silverlight/#GridView/DomainDataSource

ADO.NET services: http://demos.telerik.com/silverlight/#GridView/Services/DataService


Best wishes,
Vlad
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
0
Gopal
Top achievements
Rank 1
answered on 08 Dec 2009, 07:50 AM
Well thanx again. ! i am following the same examples but i dont know how to create wcf for telerikcontrols . the tutorials that i have downloaded from the site has everything but the connection to the wcf is not clearly described.

but at the point : 
  • Add a reference to your ADO.NET Data Service.
  • In the NorthwindDataSource class add a reference to an ObservableCollection of Customers.
  • In the NorthwindDataSource class add a reference to the NorthwindEntities object: 
public class NorthwindDataSource
{
private static NorthwindEntities northwindEntity;
public NorthwindDataSource()
{
northwindEntity =
 new NorthwindEntities( new Uri( "http://localhost:52981/Services/SampleAdoNetDataService.svc/" ) );
this.Customers = new ObservableCollection<Customers>();
}
public ObservableCollection<Customers> Customers
{
get;
set;
}
}



I am getting confuse. in the above stage. can u pls sort the problem.
0
Vlad
Telerik team
answered on 08 Dec 2009, 08:50 AM
Hi,

 I've attached two example projects to demonstrate you both binding approaches.

Best wishes,
Vlad
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
0
Gopal
Top achievements
Rank 1
answered on 08 Dec 2009, 09:51 AM
Hi there. i m following your example. But in code behind page (MainPage.xaml.cs)
 in the event
  private void RadGridView1_Filtering(object sender, Telerik.Windows.Controls.GridView.GridViewFilteringEventArgs e)
        {
            using (DomainDataSource1.DeferLoad())
            {
                foreach (Telerik.Windows.Data.FilterDescriptor d in e.Removed)
                {
                    RemoveDomainDataSourceFilterDescriptor(d);
                }
                
                foreach (Telerik.Windows.Data.FilterDescriptor d in e.Added)
                {
                    AddDomainDataSourceFilterDescriptor(d);
                }
            }
        }


the bold (Removed) option is not coming in my program.
what i m lacking:
i have imported all the required namespaces:


0
Vlad
Telerik team
answered on 08 Dec 2009, 09:59 AM
Hi,

 I'm using our latest binaries which will be uploaded later today as our official Q3 SP1. Can you post more info about your version?


Kind regards,
Vlad
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
0
Gopal
Top achievements
Rank 1
answered on 08 Dec 2009, 10:07 AM
hi !
 well i dont knw abt the exact version.But i have download the radcontrols 2weeks back.  its Q32009 without sp1

0
Vlad
Telerik team
answered on 08 Dec 2009, 10:22 AM
Hello,

 You can remove this code or wait a bit for our SP release.


Kind regards,
Vlad
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
0
Gopal
Top achievements
Rank 1
answered on 08 Dec 2009, 10:24 AM
hi thax for ur wonderful efforts.
well how long i have to wait. And do we have some alternate option ? 
0
Vlad
Telerik team
answered on 08 Dec 2009, 10:29 AM
Hi,

As I said in my previous post our service pack will be available later today.


Best wishes,
Vlad
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Tags
GridView
Asked by
Gopal
Top achievements
Rank 1
Answers by
Vlad
Telerik team
Gopal
Top achievements
Rank 1
Share this question
or