Querying Remote Data Stores From Application?
Dec 5, 2010
I am writing an ASP.NET application that suppose to connect to many different data stores and query them for data. Each data store contains different data: it can be an SQL DB, an XML file, or anything that can store data. The result is always an XML.
The remote data stores expose a WCF service (which I will also implement) that will allow me to query the data store and return the results.
My question is: how exactly should I implement the querying mechanism? Should I define my own query language?
View 1 Replies
Similar Messages:
Mar 17, 2010
I would like to write an MVC application that accesses multiple data stores (SQL Server, MySQL, Cloud based, etc.).Most of the examples I see use LINQ to SQL for their data access but I read somewhere that LINQ only supports SQL Server - it may have been an old post.I was wondering what the best way to access these different data stores would be. Can I use the Data Access Application Block from MVC to access these data stores?
View 4 Replies
May 3, 2010
I have developed a data querying application for the Web, this is in a host. What steps should I take if I want this application can also be used with mobile devices.
View 3 Replies
Feb 22, 2011
I have defined a public static HashTable. It stores data for a few seconds of runtime, and then data disappears, and then the HashTable becomes null.What is the issue and how do I solve it?
View 1 Replies
Mar 2, 2010
I have a little problem with a query. I'm selecting data using the between command, But when I select the initial date equal to the final date the query doesn't show data.I know that the problem is the format. In my database I got something like this:2009-05-22 15:32:52.000. But when I send the date parameter from ASP.NET Page I sent only the Date (2009-05-22).So, I want to fix this thing. I cannot change the Datetime inside the database.I was thinking adding 1 day to the final date, So when the user select the same date I change the range behind the scene and then show the data. What do you think?
View 8 Replies
Mar 15, 2010
I'm hoping someone can point me in the right direction. I will be as detailed as I can in explaining the issue;I have a dataset I have instantiated in a class file (vb.net), and fill the data succesfully. That data is then dumped into an excel file. What I need to do is to go through all the data in the dataset, and directly update the database, changing a "status" column from "pending" to "processing" based on the store number. As I am new to datasets (relatively speaking, of course), I am not quite certain how to accomplish this task. Below is the code I have so far:
[Code]....
If anyone could provide sample code to use, or could provide a quick bit of code I could just copy and paste in and test,
View 1 Replies
Sep 20, 2010
I have a dropdown list inside gridview which has a object data source and I am adding the list items as true, false which stores in the database table as a bit value. Even if i am addin the values 1 and 0 to the drop down list, its throwing the below error'grdDebug' has a SelectedValue which is invalid because it does not exist in the list of items.Parameter name: value My code to add the dropdownlist with list items are as below
<asp:TemplateField HeaderText="Debug">
<ItemTemplate>
<asp:DropDownList ID="grdDebug" runat="server" AutoPostBack="false" SelectedValue='<%# Bind("Debug") %>'>
[code]...
View 2 Replies
Feb 1, 2011
If I store all my user info, upon login, in cache and just have a "my account" page that displays the user info from cache, is that a good practice? I'm wondering if a person changes his email or does any type of database modification then the cached variables will be the wrong ones. If I have to update the cache variables every time something happens to the database, is this even a good practice compared to just querying the data whenever needed?
View 3 Replies
Jan 10, 2011
I'm trying to create a search page that searchs one specific table in the entrie datbase.Basically someone writes what they want in a textbox in search.aspx, they click the search button, and it takes them to another page called search_results.aspx, carrying the inputted text along with it. What search results is supposed to do is at page load, its supposed to query the entire database for all values that are LIKE the text in the querystring, then transport the entire value set of each row that has a field matchign the query string, and then it's supposed take those values and put them in a template that presents them in the way that I want.
The only thing out of all that that I don't know how to do is write the code for taking the querystring and putting it up against all the values in the database like that. I know that you can find a value in a specfic comlumn, i.e.
SELECT Column1, Column2
FROM Table1
Where Column1 = 'blah1', 'blah2'
but how do you write it so that it looks at all the columns for 1 or 2 specfic values (the querystring), and then it returns the entire for each time it finds them?
View 7 Replies
Feb 5, 2010
We are trying to add a new page to a running web application. such that a new dll and aspx file are being added. I've setup break points in the code file and Built the application transfering the dll to the remote machine bin file and the aspx page to a folder within the web application. Note this folder is not in the same folder hierarchy as it built in. I'm not sure if thats the problem. Basically we are appending new functionality to a web application.I've copied the correct Remote Debug Monitor to the server and have it running.
View 1 Replies
Dec 3, 2010
Is it possible to connect to a Remote Desktop from my ASP.net application,If so can you guide me through it.
View 1 Replies
Aug 2, 2010
I am on SBS 2003. Whenever I approach either ipaddress/remote, ipaddress/monitoring or ipaddress/backup I get the error below. When I do ipaddress/Exchange or ipaddress/newvirtualdirectory it works allright. This situation happens when I appraoch that site from a wan, from a lan and local on the server itself. This is the error message I get:
[Code]....
View 2 Replies
Dec 8, 2010
I recently developed a LINQ to SQL web application in Visual Studio 2010 on my desktop (Windows XP). It uses a connection to an SQL Server 2008 Express database on a remote server running Windows Server 2003.
When I test the application (Ctrl + F5), it works well. Now I want to publish the application on the remote server, but have run into difficulties.
I packaged the application using the "Build Deployment Package" option in Visual Studio. I installed msdeploy.exe on the server and transferred the package over. I ran "application.deploy.cmd /Y" to deploy
the application and got output indicating that files had been copied.
The deployment created a virtual directory under the default web site in IIS 6.0 and copied the necessary application files to the C:InetpubwwwrootApplication directory. However, when I attempt to browse
to the site from IIS Manager, I get a 404 error. This happens for all pages (not just the main page). So I can't get to http://localhost/Application_deploy/ and I also can't get to http://localhost/Application_deploy/Default.aspx. I mention this because
when I googled the issue, I found a lot of help for people who could get to Default.aspx but not to the main page. I don't think this is my problem.
I should mention that there is another virtual directory on the default website (I think it installed with IIS 6.0) that seems to be working fine. I was also able to publish the website on my local machine
using the one-click publish method and that works fine. My local machine runs IIS 5.1. At this point, I believe it's probably a configuration issue, either in IIS or in the application itself, but I haven't been able to solve it.
View 5 Replies
Nov 22, 2010
I have an asp.net web appilcation created in .net 2.0 that is supposed to read and display the app settings from remote web.config (accessible from a shared location). Is there a better way(like reading from the application's web.config ) to read the app
View 5 Replies
Apr 13, 2010
We have two application created one for webservice and other application will call the methoddefined in webservice .The problem is we want to add webservice in our application dynamically
View 4 Replies
May 4, 2010
I have developed web application i need to deploy it on remote server.i am using asp.net 3.5 ,c# 3.0 and visual studio 2008,sql server 2005.using visual studio 2008 how i can make msi file to deploy application on server
View 5 Replies
May 24, 2010
I get this error when I deploy the application on the remote server. This application works fine on my local machine though. It is built in MSVisual studio 2008.
View 2 Replies
Jul 16, 2010
I'm trying to upload an asp .net application
View 3 Replies
Feb 14, 2011
I want to write text file on remote location using .NET application. So can anyone tell me how to do this.
View 5 Replies
Nov 2, 2010
i want my application to provide a web ui for remote access, but i do not host that web page in IIS, because i do not want everyone install IIS on their home PC.
i spend some reading the asp.net pipeline, but still not figure how to load the .aspx file in my code.
View 16 Replies
Jan 25, 2012
So, I've been working on an app that extracts a picture from an ole field in an old access xp db, converts it to a jpg picture, and saves it to a folder to be presented to the user.
After tweaking some permissions on the local iis, the application works fine.
In the remote one however, the application doesn't extract the picture as expected.
I'm using two dlls on there, although I don't know why it wouldn't work.
View 3 Replies
Jul 10, 2010
Debugging running remote web application
View 1 Replies
May 23, 2010
i built an web application that need to work with sql server 2005, i'm using
linq to sql for my queries, and i'm using the dataclasses.dbml object.
the problem is that i can't see the database in the server explorer, so, i can't drag and drop
the tables to the dataclasses.dbml object, i understand that the application need to be rgistered
in the sql server to be able to do so and to be able to read and write to it.
View 1 Replies
Sep 30, 2010
I have some shell scripts on a Windows 2003 server. These scripts process some flat files and upload data to Oracle using sqlldr. Currently I'm using telnet to go into the box and run each of these scripts manually. Is there a way that these scripts can be run from a ASP.Net/Winforms application?
View 1 Replies
Mar 21, 2011
While running an app from the server where it is deployed the website works fine, however when trying to access it from a different machine(placed in same network), using the same credentials, it shows that I am not an authenticated user.
[code]....
View 13 Replies
