Fetching And Updating Data From Web Service?
Apr 1, 2011Data can be fetched into an application through web service can it be possible to update data in web service from our application ..
View 2 RepliesData can be fetched into an application through web service can it be possible to update data in web service from our application ..
View 2 RepliesI am creating a web app with sql server 05 and visual studio express 08. There is always live data inserted into my sql tables throughout the day infrequently.
I want to create a web page that will show the data in graphs etc. I can currently show the data present in the database on the web page. HOWEVER what i do not know is how to update the page (graphs) with the NEW DATA that has been inserted into the tables.
I guess I will have to use ajax to change the data shown on the web page automatically. I will also need somesort of triggers to tell when new data has arrived.
Basically we have a web service that the client uses to get all sorts of information, works well. Now I would like the client to call our web service, and for us to update our database based on the information getting passed (just a bool, and time).This will be used to determine what stage the client is at (they do QA). Is this possible?
View 1 RepliesI'm trying to insert a new EF object containing a reference to a related table via foreign key, and cannot get the reference stored in the new object. I have two tables in a SQL Server 2008 Database:
Component Templates
PartGroups
with a Foreign Key linking them thus: ComponentTemplates:ID [0..1<->*] PartGroups:ComponentTemplateID
I have imported these tables into a .NET web application project .edmx file (using a new ADO.NET Entity Data Model), and then created a Data Service which I then reference in a Silverlight 3.0 project. The objects are available as expected in the data context called by my Silverlight app and load correctly. Now, when I try to save a reference of ComponentTemplate into a newly created PartGroup, the PartGroup object is created in the database, but the value of ComponentTemplateID in the newly created table record is NULL.
[Code]....
(Note that _ctCtrl.ComponentTemplate is a confirmed non-NULL object reference to the parent object on which PartGroup is a child)
if I have this URL:
[URL]
How can I fetch the first two information from it into my aspx page? for example I want to read the first two timings.. Should I use xmlReader or what?
1)usign execute scalar i will get 1st col and 1st row value.
2)using dataset i will get whole table.. if my stored proc has 2 queries then i will get 2 tables within same dataset.. i can reference therese using ds.tables(0).rows(value).
3)suppose i use a datareader then i will get multiple-rows. i want to know how to get these each separate rows coloumn values into variables. below is the reader aspx.vb
reader = cmd.ExecuteReader();
while (reader.Read()) {
4)what is it mean by data reader is forward only method of getting data.
5)why do we do readeritem.tostring()
6) can you tell me the basic how is this reader,ds,scalar works.i mean i know to use but donot know basics esspecially the dataadpapter.why do we fill it when using dataset.
I want to fetch data from separate tables in sqlserver and display them together in GridView, Is that possible?
View 3 Replieswhat's the best and most likely way to fetch data from database...
View 5 RepliesI have a webservice - called MyCompany.WebService1
I reference this using a web reference in my ASP.net web application.
Theres a method called "GetDeal" in this web service, that returns a "Deal" Object.
The deal object currently looks (for example) like this:
[code]....
This class is in a different assembly: MyCompany.Model
The web service references this assembly.
In my web app, I can call the GetDeal method. This returns Service1.Deal (service1 is just the name of the web reference)
I can access both properties above. I have now changed the Deal class, and added a couple more properties.
However, I can't see these new properties in my web application. I've updated the web service in the web application. I rebuilt the web service several times, tried removing the MyCompany.Model reference and re-addding it etc...
I can't figure out what has changed... This was working - I have changed the model before, and it's updated the reference correctly...
I am trying to update client side controls asynchronously with information from a service.
The service I am using has a callback delegate that points to the users web page (server side)
I would like to update information on the page that is initiated by another users also consuming the same service. exactly like a chatroom.
I am trying to use an update panel, and call updatepanel.update() (server side) once I recieve the information from the service. basically: how do I partially update control data from the server side so that client side can see it.
I need to do parallel processing in my coding because i have 4 sql to fetch data from database which each take me 3-4 minutes.All the tables involved are raw table and that is no way i can reduce the time for the sql.I need to find a way out to reduce the data fetching time.The only thing i canfigure out is to have this 4 sql execute at the same time by doing parallel processing.
View 4 RepliesI have a problem at the time of updating the datagrid. I want that at the time of update data is shown in form instead of datagrid.
[code]....
I have a webservice which needs to query the Database every hour to get the latest copy of the data. What would be the best way to have the websevice call a method every hour. I am condering using the imers.Interval to call a method every hour.
View 3 RepliesI have a gridview which is present inside a repeater. I have been successful in displaying the data inside the grid view. Now I want to fetch data from the gridview. But i have not been able to fetch the data from the grid view.
View 5 RepliesI have two databases (DB1 & DB2) from which i wish to build a single table/gridview output, ideally i want to be able to sort the table by using any data.
However i cannot seem to figure out how to have more than one datasource per Gridview, and if i have more than one Gridviews then i can't sort all the data by any of the columns.
This is a oneway street, i do not want to update the databases from the webfront end.
Here is a Trimmed Down Version of what i have
[code]....
I want to show processing .gif image while submitting data or fetching data?
For example,When we search for hotels in any city after clicking search we have a model popup which ask you to wait and shows processing image.
My application has GRID VIEW control, which displays, Folder Name and Folder Path. While rendering in the webpage, i want to display only the Folder Name. For this, i set the visible property to false. Now iam able to display only Folder Name column.
Now the problem is, though iam hiding the Folder path column, i want to retrieve, the Folder path, when user clicks on submit button. Iam getting empty value for the hidden column.
I am fetching data from oracle data base in asp.net application. To achieve this functionality i have used Oracle.DataAccess dll . In my developement enviorment it working fine.
But once I deployed this code on IIS 6.0 it is stopped working and I checked my log and found connection not get established . Then I make sure Oracle.DataAccess.dll present in to bin folder also I try to put this dll in side GAC, but still my code is not working on deployed server.
Lets say i'm retreiving some data or string to the server using a webservice. How can i insert a preloader?
View 3 Replies[Code]....
I have a List View lstViewAB , by the above code i m trying to find the text on the lblMobile for those which are checked (checkbox). But the problem is that the text of label lblMobile is fetched of 1,3,5 rows only and for 2,4,6 rows it shows text "".
I am able to fetch the data from LDAP localy thru bellow coding, but i am not able to fetch the data when i am this page in IIS. page is comming but there is not data here is my coding
[Code]....
I am trying to fetching the data from Book1.xlsx file. The program is not working and throws an exception. check the code and tell me where I am doing the mistake?
[Code]....
The exception is:
An error: The Microsoft Office Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data.
I have two tables
1. Table1
Mandli_name, latitude, longitude
2 . Table 2
Mandli_name, daily_collection, collection_date
I want to show daily collection of the mandli on the google map info window. .According to date input ....so I want to how can I fetch the data from two different table..
User enter date in the textbox and click search button that is my scenario. ..
in gridview i hv columns like
name | phno. | emp_name(in dropdown) | buttonfield
wen user comes on this page this grid comes filled but then I need to select 1 emp_name from dropdown and click button(in last column) corresponding to that row. then on clicking that row button it should fetch that toq Primary Key and dropdown corresponding id. how? Wen I m fetching its fetching row index as 0 though it is no.4 record as per database(coz my records are in desc.order). I mean its giving row index as per grid and not as per my actual table(primary key).
I am trying to update a row of the child gridview through a link button template field but how do I fetch the datakeys of the child gridview ?
View 1 Replies