.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Imran Ghani
Post New Web Links

Need to create a service to allow client application to update their data

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :ASP.Net
 

Hi,

I want to create a  WCF Service to transfer data to our clients application(WPF).

The Data I am trying to send is as follows.

ID  Code          Description   unit    Rate

1   104200000   LIVE GOAT      NOS     25

2   104200000   LIVE GOAT2    NOS    25

3   104200030   LIVE GOAT3    KGS     10

4   104202030   Water             LTR      5

and so on till ~ 11000 records.

What I have done so far is. Created a service which return a list of data.

-----------

 public List<Classes.TariffData> GetTariffData()
{
var currentTariffData = new List<Classes.TariffData>();

using (var myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
const string query = "select a.ID,a.Code,a.Description,a.unit,a.rate,a.rate3 from tariff.dbo.tariffdata a, tariff.dbo.code_history b where a.id = b.id and b.endofvalidity is null";
using (var myCommand = new Sq


View Complete Post


More Related Resource Links

Consume WCF Data service in client application

  
Hi All, I am working on WCF Data service which imported stored procedure, as below.         [WebGet]        public List<GetMTSearchResultTest_Result> GettMTSearchResultTest()        {            MediaMarketResearch_PRODEntities ent = new MediaMarketResearch_PRODEntities();            return ent.GetMTSearchResultTest().ToList();        } when i consuming this in my client application it says error as "The closed type MMRClient.MMRServiceReference.GetMTSearchResultTest_Result does not have a corresponding element settable property." I am getting this error while bind to the grid view as below. DataServiceContext context = new DataServiceContext(new Uri("http://localhost:4131/MMRDataService.svc/"));IEnumerable<GetMTSearchResultTest_Result> empResult = context.Execute<GetMTSearchResultTest_Result>(new Uri("http://localhost:4131/MMRDataService.svc/GettMTSearchResultTest"));             GridView1.DataSource = empResult;            GridView1.DataBind(); Note: I imported this sto

Consume WCF Data service in client application throws error

  
Hi All, I am working on WCF Data service which imported stored procedure, as below.         [WebGet]         public List<GetMTSearchResultTest_Result> GettMTSearchResultTest()         {             MediaMarketResearch_PRODEntities ent = new MediaMarketResearch_PRODEntities();             return ent.GetMTSearchResultTest().ToList();         }   when i consuming this in my client application it says error as "The closed type MMRClient.MMRServiceReference.GetMTSearchResultTest_Result does not have a corresponding element settable property." I am getting this error while bind to the grid view as below. DataServiceContext context = new DataServiceContext(new Uri("http://localhost:4131/MMRDataService.svc/")); IEnumerable<GetMTSearchResultTest_Result> empResult = context.Execute<GetMTSearchResultTest_Result>(new Uri("http://localhost:4131/MMRDataService.svc/GettMTSearchResultTest"));             GridView1.DataSource = empResult;             GridView1.DataBind(); Note: I im

Consume WCF Data service in client application throws error

  
Hi All, I am working on WCF Data service which imported stored procedure, as below.         [WebGet]         public List<GetMTSearchResultTest_Result> GettMTSearchResultTest()         {             MediaMarketResearch_PRODEntities ent = new MediaMarketResearch_PRODEntities();             return ent.GetMTSearchResultTest().ToList();         }   when i consuming this in my client application it says error as "The closed type MMRClient.MMRServiceReference.GetMTSearchResultTest_Result does not have a corresponding element settable property." I am getting this error while bind to the grid view as below. DataServiceContext context = new DataServiceContext(new Uri("http://localhost:4131/MMRDataService.svc/")); IEnumerable<GetMTSearchResultTest_Result> empResult = context.Execute<GetMTSearchResultTest_Result>(new Uri("http://localhost:4131/MMRDataService.svc/GettMTSearchResultTest"));             GridView1.DataSource = empResult;             GridView1.DataBind(); Note: I im

User Profiles Service Application and Import of SharePoint 2007 SSP data

  
I have setup a test SharePoint 2010 Farm. I will be using this as a test upgrade of a current live SharePoint 2007 Farm. The database attach method will be used. I have replicated the web application and AAM settings of the SharePoint 2007 Farm to the SharePoint 2010 Farm and have made the 2010 Farm a DC in a new Forest. I don't want to join this to the current domain at the moment. It also has SQL server 2005 with SP3 and cumulative update 3 installed. I have just setup the User Profiles Serice Application and when I go to Manage it, I get this. Error An unexpected error has occurred.   Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: a1760e87-372f-4711-afac-3ceba34bc599 Date and Time: 8/31/2010 4:22:56 PM I have verified and configured the following. Created the Managed Metadata Service. The status is started via Service Applications and Services on Server. Created the User Profiles Service Application and ensured status is started via Service Applications. I started the User Profile Service and User Profile Synchronisation Service via Manage Services on Server.      

Error selecting "Business Data Connectivity" service application in MSS 2010 with WCF hotfix on W8R

  
I'm getting "BDC Metadata Store is Currently Unavailable" when navigating to the External Content Types object in SPD 2010. Hot fix is installed.  No errors in the eventlog? 

jQuery & WCF Data Service - PUT Update - Rejected with 405 Method Not Allowed

  
I am writing a sample jQuery/WCF Data Service app to utilize OData, however I am getting a status code 405 - Method not allowed when I attempt to update an entity with a PUT Http method. I have configured my WCF Data Service as follows: public static void InitializeService(DataServiceConfiguration config) { config.SetEntitySetAccessRule("jCredentials_PINs", EntitySetRights.All); config.SetEntitySetAccessRule("jCredentials_PINTree", EntitySetRights.All); //config.SetServiceOperationAccessRule("MyServiceOperation", ServiceOperationRights.All); config.DataServiceBehavior.MaxProtocolVersion = DataServiceProtocolVersion.V2; } I am attempting to update the jCredentials_PINs table. My jQuery call to update the WCF Data Service is as follows:function UpdatePIN(selectedTreeNode, updateObj) { var url = dataService + "/jCredentials_PINs(guid'" + selectedTreeNode.get_value() + "')"; var json = JSON.stringify(updateObj); $.ajax({ url: url, data: json, type: "PUT", contentType: "application/json; charset=utf-8", timeout: 10000, dataType: "json", success: AjaxPINUpdateSuccess, error: AjaxPINUpdateFailure }); } function AjaxPINUpdateSu

Create a new target application - Secure Store Service administration issues

  
Hi,I am trying to create new target application, when I go to Secure Store Service in Centra admin I have:Cannot complete this action as the Secure Store Shared Service is not responding. Please contact your administrator.I have used this few days ago and avarything else is working fine on the server, and I have applications created with it running fine.Any help is appreciated.cheersValko

Client Application Services - Role service cache time out bug

  
Hi All, For people using Client Application Services with WPF, be aware of this bug. You can configure the "cache time out" for roles to be fetched again from the service. (In the visual studio dialog, Properties -> Services -> Advanced) This means the roles are cached on the client (in a file). If the application asks for roles again, they are not fetched again for "cache time out" time. When you set this value, it goes into your App.config, transformed into seconds. So if you choose 1 minute, the App.config has: cacheTimeout="60".   However, when using the ClientRoleProvider (for instance to do something like clientRoleProvider.GetRolesForUser("SomeUser")), this cacheTimeOut is interpreted in Minutes, not seconds! To prove my point, check ClientRoleProvider.Initialize method:   string temp = config["cacheTimeout"]; if (!string.IsNullOrEmpty(temp)) _CacheTimeout = int.Parse(temp, CultureInfo.InvariantCulture);   Later on, in ClientRoleProvider.GetRolesFromDBUser (what's in a name?), you see: _CacheExpiryDate = cd.RolesCachedDateUtc.AddMinutes(_CacheTimeout);   Testing also shows this behavior. So be aware, and always put the value in minutes in your App.Config!   Regards, Koen

consuming wcf Data service in different format in client - SOAP (including a WDSL), XML, JSON, etc.

  
Hi I have implemented wcf data service with entity framework with the following steps, i want to know i can we consume this WCF Data service in different format like (SOAP, JSON, XML, PLIST). it will be helpfull if some one help on this. - Created web application with VS2010 and added edmx file and selected tables,views and SPs that i want to use - imported SP with complex type by using function import. - Created WcfDataservice (.svc File). - in SVC File i have added [webget] method as follows.         [WebGet]        public List<GetSearchResultWithComplextype_Result> GetSearchResultComplextype(string email, string Title, string Color)        {            Entities db = new Entities();            var query = db.GetSearchResultWithComplextype(email, Title, Color);            List<GetSearchResultWithComplextype_Result> caseList = query.ToList<GetSearchResultWithComplextype_Result>();            return caseList;        } - created one more client application and added service reference. here i want to cons

consuming wcf Data service in different format in client - SOAP (including a WDSL), XML, JSON, etc.

  
Hi  I have implemented wcf data service with entity framework with the following steps, i want to know i can we consume this WCF Data service in different format like (SOAP, JSON, XML, PLIST). it will be helpfull if some one help on this. - Created web application with VS2010 and added edmx file and selected tables,views and SPs that i want to use - imported SP with complex type by using function import. - Created WcfDataservice (.svc File). - in SVC File i have added [webget] method as follows.         [WebGet]         public List<GetSearchResultWithComplextype_Result> GetSearchResultComplextype(string email, string Title, string Color)         {             Entities db = new Entities();             var query = db.GetSearchResultWithComplextype(email, Title, Color);             List<GetSearchResultWithComplextype_Result> caseList = query.ToList<GetSearchResultWithComplextype_Result>();             return caseList;         } - created one more client application and added service reference. here i wan

how to update data in the intranet application through Internet

  

my application is in Intranet,  but in my application mail is trigger to the user, and in that mail (outlook) user getting one link of that application so that he can update "YES"

My problem is that when the user is not in office and he is using Blackberry, at that time intranet link will not work.........

so, any solution that anybody can update through internet.

 


How to update Domain Service from Entity Data Model?

  

Hi guys,

So I'm using Entity data model to reflect my database and I generate Domain service from my Entity data model.

I understand that if I have changes in my database, I can just choose "Update Model from Database", but there is no "Update Domain service from Model" option available.

How should maintain my domain service? I'm not going to delete away it and regenerate it whenever there are some changes, right?

I need to know what if

- I add in new table in my database, how should I update from database-->model-->domain service?

- I add in new fields in my table, how should I update from database-->model-->domain service?

Thanks.


Client Application Service

  

 

Hi,

we are in the process of architecting a security framework for our applications and we are looking at the Client Application Services availbale i .NET.

 

If I decide to use the ASPNETSQLMemebrshiprovider would i be able to use a single application service for all my applications.

 

if so when an application uses the the application service to authenticate how will it identofy which applicatio to authenticate against.

 

Any suggestions will be grealty appreciated.

 

Jothi

 


How to Consume WCF service In My CLient Application After Installing the WCF service at Production E

  

Hi,

 I ahve created the WCF service and Client Application To consume that Service and Everything Tested and working perfectly.

But to Giv that Application to the Client we have give the 2 Installer

1)Server Instller(WCF  Service Installer)

2) Client Installer having Some forms and Logic to consume WCF service.

 

My question is that..

While Installing the Service(WCF) service at production evnironment if they gives some name.

How my client Application Knows that Service?Is there any way to do that

Please Help me

--Regards,

Amar


Thanks&Regards, -Amar.

Return ReadOnlyCollection from WCF service and use it in Silverlight 3 client application

  
Hi all!

I have a solution containing of 3 parts: wcf service, wpf app and silverlight 3 app.
Both wpf app and silverlight app use wcf service to get a collection of objects.

The point is that my business requirements insistently tell me to return ReadOnlyCollection<T> from wcf service.
When I try to do it I have Serialization exception in silverlight client app. But it's ok in wpf app.

Then, I haven't started the investigation for such strange thing (different behavior in wpf and silverlight) and decided to implement custom serialization, returning the ICollection interface and trying to get ReadOnlyCollection on deserializing.  But wcf service proxy class in silverlight app returned Array of T, not ReadOnlyCollection<T> as proxy in wpf did.


So, the question is: Is it possible to return ReadOnlyCollection<T> from WCF service?



Any help is appreciate.

Thanks,
Dmitry

Design Data Contract for User Create/Update/Delete REST API using WCF 3.5 & JSON

  

Hi,

I'm using REST with WCF .NET 3.5. I've design the class structure with below JSON struvture of input & output.

API 1: Create User: POST /id & request body is as shown below:

{
  "userList" :
   [
    {
       "name" : "<name>",
       "email" : "<email>",
       "dataId" : <dataId>,
       "country" : "<country code>",
    },
    {
       "name" : "<name>",
       "email" : "<email>",
       "dataId" : <dataId>,
       "country" : "<country code>",
    }
   ]
}

The response object should be as shwon below:

{
  "userCreateResults" :
   [
    {
       "email" : "<email>",
       "userId" : <userId>,
       "password" : "<password>",
       "result" : <result code>
    },
    {
       "email" : "<email>",
       "userId" : <userId>,
       "password" : "<password>",
       "result" : <result code>
    }
   ]
}

API 2: Update User: PUT /id & request body is as shwon below:

{
  "userList" :
   [
    {
       "userI

How to use Designer to create a WF to collect data and update item in the list

  

Hi,

I’m trying to create a workflow in SharePoint Designer 2007 to finish the item in the list. In the list, I setup 10 fields (Name, Address, Phone#....), and in the workflow, I set it to start automatically when a new item added in the list (I can add a new Name in the list to start the workflow).

 

In the step1:

The Conditions is: “If Address is empty”.

The Actions is: “Collect all data from lw1990 (Output to Variable: collect1)

 

At this point, I don’t know how to update the current item in the list with the data that just collected from user in Variable:

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend