ADO.NET Data Service Doesn't Update
Jul 22, 2010
I've a problem updating objects with the ADO.NET Data Services.
First I've create a service, which can load and store the data. Its a basic data context which implements the IUpdatable-interface.
After that, I've created a simple service-client. I just created it with the 'Add Service'-reference in Visual Studio. Basically this service seams to work. I can query for the objects and store new objects. However I cannot update objects.
This is my update-code on the client:
var ctx =
new TeamDataContext(new Uri("http://localhost:8637/TeamInfoService.svc"));
var team = ctx.Teams.First();
team.TeamName = "New Team Name";
ctx.UpdateObject(team);
ctx.SaveChanges();
What my main issue is, that IUpdatable.SetValue() isn't called for the object which I want to update. Only the IUpdatable.SaveChanges() is called without updating the objects on the server.
When I create a new object, the IUpdatable.SetValue is called on the server to set the property.
So what I am doing wrong? Are my expectations wrong? Is IUpdatable.SetValue supposed to be called when updating a object? Or do I need to do additional things to do updates?
Edit: I just watched the HTTP-requests between the client and the server. The client send a HTTP-Merge request with the changes. However I still don't know why the changes aren't stored.
View 1 Replies
Similar Messages:
Oct 22, 2010
For right now, the View Account for an individual user has the following setup on the aspx page.
[Code]....
In the MembershipUserODS file i have the following:
[Code]....
And in the code behind page i have this...
[Code]....
The page posts, when you click the update button, but the data never changes / updates.
View 3 Replies
Apr 12, 2010
I have a typical gridview/formview master control setup. When I try to update or insert I don't get any errors but it also doesn't work. When I try to insert data all I get are null values and when I update, none of the values are updated. The formview looks like its working, but just doesn't. The primary key is an identity and it auto-increments by one.
[Code]....
View 3 Replies
Jul 16, 2010
as seen from the title my sql doesnt update the data that has been inserted by my function. But in my function it works perfectly as it returns '1' when i executenonquery. however it only works when i insert a record which has a date later than today's date. which is weird as there is no validation in that page and if there were to have a validation, it would not run the function.
View 10 Replies
Jul 10, 2010
I use ADO.net Entity Data model for work with database.
In my program, I want to update a record of user table, so I use the code below to do this.
In this function I send changed user info and then overwrite the information with the current user information.
After I run objUser = _user; and then call objContext.SaveChanges(); to save the changes.
But when I do this, the changes are not persisted to the database. I use this code for another programs but in this case the code does not work!
public void Update(tbLiUser _user)
{
LinkContext objContext = this.Context;
tbLiUser objUser = objContext.tbLiUsers.First(u => u.tluId == _user.tluId);
objContext.Attach(objUser);
objUser = _user;
objContext.SaveChanges();
}
View 1 Replies
Nov 16, 2010
I have a page that binds data from DB to a DetailsView.I want to use the auto-generated Update command.
Everything went OK, and also updating was successful, but if I remove any field that I don't want to have chance to update, then the Update command doesn't update! the old values retain!
I mean: if all of the fields are present in the detailsView, the update will be OK, otherwise, the update will NOT update any thing.I've tried to mark the fields that I don't want to view as "Visible = 'false'" but with no good results!
View 2 Replies
Sep 27, 2010
I have a vb.net page that has an optional parameter. If a user enters data for that field, and clicks save, it saves fine via the stored procedure. HOWEVER, if the user changes their mind, and wants to erase the data they entered, they go to the text field, and delete the characters, and click save, but no matter what, the stored procedure will not save the fact that they erased the data (it won't set it back to NULL). If the user enters a space, the stored procedure will save the space, and if they enter different data, it will save the other data. I can't figure out how to get it back to letting them set it to Null? I think this is because it's an optional parameter, and the stored proc is used by several forms (Some of those forms do not include this parameter), but this form utilizes that optional paramater.
Here's my stored procedure...
[Code]....
[Code]....
View 2 Replies
Jun 21, 2010
What's wrong with the following code?
[Code]....
After the SubmitChanges call, the Text field in data2 wasn't changed. According to the NerdDinner sample, I supposedly can just write to my data object and then call SubmitChanges.
View 5 Replies
Nov 23, 2010
Can't tell what is wrong here . It worked fine and I didn't did anything special in code-behind
I don't see any error just the same data in gridview
[Code]....
View 7 Replies
Jan 1, 2010
see my jpg picture to identify problem easly
[URL]
when i change quantity up it s increasing 1 but sum doesnt increasing if i click twice its increasing but wrong where i am doing wrong
my code is
[Code]....
View 5 Replies
Oct 5, 2010
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?
View 1 Replies
Sep 22, 2010
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 SqlCommand(query, myConnection)) { using (var ad = new SqlDataAdapter(myCommand)) { var dt = new DataTable("tariff"); ad.Fill(dt); currentTariffData.AddRange(from DataRow row in dt.Rows select new Classes.TariffData { Id = int.Parse(row["Id"].ToString()), Code = row["Code"].ToString(), Description = row["Description"].ToString(), Unit = row["unit"].ToString(), Rate = row["rate"].ToString(), Rate3 = row["rate3"].ToString() }); return currentTariffData; } } } }
Class is as follows
public class TariffData { public int Id { get; set; } public string Code { get; set; } public string Description { get; set; } public string Unit { get; set; } public string Rate { get; set; } public string Rate3 { get; set; } }
If i Limit the number of data by using const string query = "select top 300 a.ID,a.Code,a.Description. The Service works fine. But if I remove the top 300 part I get an error. What is your advice if I want a service to allow our client applications to update their data by using WCF. (11000 records.) I am using visual Studio 2010. C# .Net 4.0
View 3 Replies
Sep 12, 2010
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:
[Code]....
I am attempting to update the jCredentials_PINs table. My jQuery call to update the WCF Data Service is as follows:
[Code]....
I am using Windows 7 / IIS 7.5. GETs against the jCredentials_PINs table work fine. The only web.config configuration information is as follows:
[Code]....
View 1 Replies
Jun 30, 2010
I created a web service on localhost, and I tried to call it from a web app (also on the localhost) via HttpWebRequest, but Application_BeginRequest in Global.asax didn't fire. When I type in IE 'http://localhost:8010/Test/' (the web service) Application_BeginRequest fires. Where is the problem? How can I test a localhost web service from a page which is also on localhost?
View 2 Replies
Mar 6, 2010
The following 'hello world' webservice works fine on my computer (VS2008) but I can't get it to work on the server--either from an aspx page (below) or when invoked directly. I get '404 page not found' on the direct invocation.
[Code]....
I added the HttpGet and HttpPost to test the web service directly on the server. I can open the page and invoke it, but then get the 404 page not found response.
View 5 Replies
Sep 15, 2010
i am developing web service to get news of share market. i use yahoo servicece result is fine but yahoo does not give most updated result of share market so i want to take help of [URL] but i am not able to find web service for this is there any help my code for yahoo service like this [URL] it if i want to use moneycontroller insted of yahoo what change need? i tried [URL] but it' not working
View 5 Replies
Sep 16, 2010
I have a text box and ajax autocomplete control extender in my Master Page that it is not working at all. When I type some characters on the text box it doesn't trigger the autocomplete. I have a web service that contains the function code. I est my code on a single Web Page (No Master Page) and it works perfectly. Also, it works fine if I include the text box and the extender on the Content Page instead of on the Master Page. It is important to keep the text box in the Master Page for me. I am using Visual Studio 2008 and ASP 3.5. MASTER PAGE.
[Code]....
WEB SERVICE:
[Code]....
View 7 Replies
Aug 17, 2010
I am trying to learn the ASP.Net AJAX and as project I decided to do a basic number guessing game. It works fine the first time a guess is submited but after the second time the number of guesses made does not update properly and I can not figure out why.
[Code]....
View 3 Replies
Feb 14, 2011
i have the follow code:
public partial class _Default : System.Web.UI.Page
{
int myValue;
protected void Button2_Click(object sender, EventArgs e)
{
myValue = myValue + 1;
Label2.Text = myValue.ToString();
}
}
I can't seems to increase the value, the outcome will always be 1.....
View 2 Replies
Mar 17, 2010
In my 2nd ASP.NET MVC project I'm facing a very weird problem: when I call the SubmitChanges method of the DataContext class, nothing updates in the database. It's weird because everything works fine with my first project. I'm using a remote database created in Sql Server Management Studio, I tried doing some queries there and in Visual Studio 2010 (where I have the connection to the database), they all work. Where might the problem be hidden?
DBDataContext DB = new DBDataContext();
var myuser = DB.Users.Single(u => u.ID == id);
myuser.Age = 45;
DB.SubmitChanges();
This is embarrassing :D Indeed I didn't have a primary key. Now it works!
View 5 Replies
May 19, 2010
I try and update my table with the following
[Code]....
I dont get an error or anything, nothing happens, and the date remains the same.
View 9 Replies
Dec 11, 2010
I have problem when i use UpdatePanel in ContentPage. In Updatepanel, I have DataGrid. Outside, I have a textbox and Button.
When i press button, I want to insert message in texttbox to Database and Select from Database for Showing in DataGrid (includes all message in past)
My MasterPage:
<ScriptManager>
<ContentPlaceHolder>
My ContentPage
<div> Have a textbox and button
<updatePanel> Have Datagrid
<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.Master" AutoEventWireup="true" CodeBehind="commentForm1.aspx.cs" Inherits="ChatApplication.commentForm1" %>
View 6 Replies
Mar 14, 2011
I have a simple table with 5 text boxes, above that i have a dropdown where you make a selection, if there are any records of associated with the selection, then i display in the fields..
A while back this was working, you could make a selection and the fields were within a update panel and they were populated. But im revisiting the pages to make some updates and changes and noticing that the page no longer populates the fields when a selection is made..
Is there anyway to debug the updatepanel? I put a breakpoint in my selectedindexchanged event and my Db call is returning values and the textboxes .TEXT values are being assigned the right values in the code behind, but the fields never show up..
This page hasnt been touched since it was wworking last, so need to see how i can test / debug the update panel to determine what coudl be causing it..
[Code]....
View 3 Replies
Mar 20, 2010
I have a Shopping Cart Summary User Control that doesn't update without a full browser refresh.
The scenario is:
I have a DataList in one User Control that displays Product data with an ItemCommand event for an 'Add To Cart' button.
[Code]....
When the 'Add to Cart' button is clicked, the page reloads and another User Control containing the Shopping Cart Summary should be updating. However, the Cart summary doesn't fully update until a full page refresh occurs.
I should add, that the Cart Summary is "located" on a master page whereas the Product List is in the Content Placeholder of a web form based on the same master page.
I can provide more of my code if required but I'm initially reluctant incase I'm making a noobish error!
View 9 Replies
Jan 12, 2011
I have my ReorderList setup, and it seems to work. It doesn't give me any errors, and it allows drag/drop of the entries.
BUT, it never updates my datasource. I have tried putting breakpoints on the update events, both on the reorder list, but also on the datasource, none fires.
What could i possibly do wrong, to achieve this?
Here's my code, just in case:
[Code]....
[Code]....
View 3 Replies