SQL Server :: TSQL Calling A Web Services (FEDEX)?
Nov 5, 2010Does anyone have a sample code on this? I want to call the FedEx "Rate Available Services/Rate Shopping" Service to retrieve pricing for various services.
View 2 Replies
Similar Messages:
C# - Server Control Library Calling Its Own Services?
Nov 18, 2010I am posting this as a part of my effort in searching the best possible design solution for my requirement. I am currently working on a complex server control(not user control) in asp.net which is going to be rendered into html elements on the client side.And those html elements needs to do a ajax call backs to the server using js/jquery. Here is the problem. As this is a serverside control and can be added into any application/domain. I dont want to have those callback services hosted separately. Is there any way that I can host those server callback services in the same library? If so, how can I access them from the client side?
View 1 RepliesSQL Server :: Reading Xml File And Inserting Data Into A Tsql Table (no Duplicates)?
Feb 25, 2011I am writing code to insert values from an xml file. I check for a duplicate before inserting and delete if there is a match. Is there a more effecient way to prevent duplicates before insert a record? my code: private void LoadFData() { SqlConnection oConn = new SqlConnection(ConnectionString); SqlCommand oCommand = new SqlCommand(); oCommand.Connection = oConn; oCommand.CommandType = CommandType.Text; oConn.Open(); // Load committee master files string[] strFiles = System.IO.Directory.GetFiles("fff", "ffff.dta", System.IO.SearchOption.AllDirectories); for (int i=0; i
View 2 RepliesCalling PHP Web Services In C#
Nov 29, 2010I want to convert following PHP code to C#.
$client=new SOAPClient(API_URL."www/ws_rpc.php?wsdl&actor=fieldreport_actions&client=".API_KEY,array("uri"=>"SOME_URL","style"=>SOAP_RPC,"use"=>SOAP_ENCODED,"encoding"=>"UTF-8"));
$auth = $client->is_valid_panelist_login("login_type_email",$username,$password);
How can I do it? I found 1 sample at: Help me convert this PHP SOAP code to C# But this looks bit different.
Calling WCF Services From Website?
Sep 27, 2010For an ASP.Net website with calls through to a WCF Service:
Three web clients click the button that calls the WCF Service simultaneously.
Does the web server make 3 concurrent calls? (e.g. WCF Service receives 3 concurrent calls) one on behalf of each web client?
Calling Multiple Web Services Asynchronously From A Web Page?
Jul 13, 2010I make an asynchronous call from one web service to another web service deployed on different server? The scenario is that an ASP.NET webforms page will call a web service in an async manner. This particular web service will then make another async call to a second web service deployed on different web server. This this possible to achieve, and what additional steps or code would be necessary to make this happen?
View 1 RepliesArchitecture :: Design On Calling Multiple Web Services
Feb 23, 2011My requirement is i need to display some quotes from some vendors in my User Interface. Some of the quote details will be fetched from database where as some vendors are giving web services to get the quote results. I need to combine the quotes from database as well as the various web service response and display in the grid.
View 1 RepliesWeb Forms :: Calling Web Services Asynchronously In Page_Load Event?
May 31, 2010I'm working on a web application using VB.NET. In page load event am calling a remote web service which take time to bring the data. During this process none of the other contents on page are shown(render).
I want to call this remote web service asynchronously so that other data of page is displayed and web service data will be displayed when its available.
How To Authenticate A Windows Mobile Client Calling Web Services In Web App
Mar 21, 2010I have a fairly complex business application written in ASP.NET that is deployed on a hosted server. The site uses Forms Authentication, and there are about a dozen different roles defined. Employees and customers are both users of the application.
Now I have the requirement to develop a Windows Mobile client for the application that allows a very specialized set of tasks to be performed from a device, as opposed to a browser on a laptop. The client wants to increase productivity with this measure. Only employees will use this application.
I feel that it would make sense to re-use the security infrastructure that is already in place. The client does not need offline capability.
My thought is to deploy a set of web services to a folder of the existing site that only the new role "web service" has access to, and to use Forms Authentication (from a Windows Mobile 5/.Net 3.5 client).
I did see this question and I am aware of the limitations that Forms Authentication poses. Since security is not my primary motivator (I use SSL and can restrict access by IP address), but rather using existing user accounts and roles, my decision tree is somewhat different as well.
DataSource Controls :: Rollback Transaction For Calling Web Services?
Apr 22, 2010I have the web form whcih processing several web services calls.
If one call failed, it will rollback transactions. But it cannot.
Due to the web services will complete for each call.
I am using sql connection and sql command.
Is it possible to do this?
Web Forms :: How To Find All The Web Services And Windows Services Running On A Server
Feb 4, 2011How to Find All the Web Services and Windows Services Running on a Server in ASP.Net. I have the server details with me and want to find all the Web services running on it.
View 1 RepliesWeb Services - Having An Ambiguous Type Error When Calling A WebMethod On .NET Web Application?
Mar 2, 2011The message sent to browser is as follows:
The type My.API.Class is ambiguous: it could come from assembly '[on Temporary ASP.NET Files]' or from assembly '[on bin folder]'
The problem occurs when debugging a Web App, speciically when making a request to a WebMethod of a WebService.The project compiles just right. It generates My.Website.dll on bin folder and if I publish the Web Application. It works fine.The asmx file is on the root of the application. The CodeBehind file is on App_Code and its marked to be compiled to generate My.Website.dll.The way this person exposes its problem is somehow similar but I get starting to be lost when he talks about a proxy class and shared dlls I don't use.
Is It Possible With Dynamic TSQL Query
Jun 3, 2010I have very long select query which i need to filter based on some params, i'm trying to avoid having different stored procedures or if statements inside of single stored procedure by using partly dynamic TSQL.I will avoid long select just for example sake
select a
from b
where c=@c
or d=@d
@c and @d are filter params, only one can filter at the same time but also both filters could be disabled. 0 for each of these means param is disables so i can create nvarchar with where statement in it...
How do i integrate in here dynamic query so 'where' can be added to normal query. I cannot add all the query as big nvarchar because there is too many things in it which will require changes ( ie. when's, subqueries, joins)
Tsql - .Net MVC Best Way To Update Cached Table
Apr 19, 2010There are certain tables that get called often but updated rarely. One of these tables is Departments. So to save DB trips, I think it is ok to cache this table taking into consideration that the table has very small size. However, once you cached it an issue of keeping the table data fresh occurs. So what is the best way to determine that the table is dirty and therefore requires a reload and how that code should be invoked. I look for solution that will be scalable. So updating the cache on single right after inserting will not resolve the issue. If one machine inserted the record all other on the farm should get notified to reload the cache.
View 3 RepliesADO.NET :: Using LINQ, How To Execute The TSQL LOG() Function
Mar 25, 2011I have a SQL view that uses the LOG() function. How can I do the same in a LINQ query?
View 6 RepliesSql - TSQL Grouping And Ordering For Dynamic Table?
Jun 7, 2010I hoping someone may be able to point me in the right direction for this. Basically Im writing an asp.net web control to dynamically display a set of data based on field data stored in the database.
I want the control to create a dynamic asp table from a set of data from the database, however I cant get my head round the query needed to order the data into a list that I can create a htmltable from (if that makes sense)
my data looks like this, where I have a field name, the order the corresponding control will be rended in, and the number of columns that control takes up in the asp table:
Id | FieldName | ColumnSpan | Order ...
-----------------------------------------
1 | UserName | 1 | 1
2 | FirstName | 1 | 3
3 | LastName | 1 | 4
4 | Email Address | 2 | 2
5 | DOB | 1 | 5
6 | Notes | 2 | 7
7 | Password | 1 | 6
8 | UserID | 1 | 0
I have made a couple of attempts at creating a stored procedure that accepts an integer representing the number of columns the table will have, with no real progress. I would like the query to return something like the following (if the input parameter was 2 (columns)) - where the fields are grouped into logical rows
row | FieldName | Order
------------------------------------
1 | UserId | 0
1 | UserName | 1
2 | Email Address | 2
3 | FirstName | 3
3 | LastName | 4
4 | DOB | 5
4 | Password | 6
5 | Notes | 7
Generate Membership Password Hash In Pure TSQL
Feb 17, 2011I'm attempting to create a pure t-sql representation of the default SHA-1 password hashing in the ASP.Net Membership system. Ideally, what I would get would be this:
UserName Password GeneratedPassword
cbehrens 34098kw4D+FKJ== 34098kw4D+FKJ==
Note: that's bogus base-64 text there. I've got base64_encode and decode functions that round-trip correctly. Here's my attempt, which doesn't work: SELECT UserName, Password, dbo.base64_encode(HASHBYTES('SHA1', dbo.base64_decode(PasswordSalt) + 'test')) As TestPassword FROM aspnet_Users U JOIN aspnet_membership M ON U.UserID = M.UserID
I've tried a number of variations on the theme, to no avail. I need to do this in pure T-Sql; involving a console app or something like that will double the work. So if anyone can supply what precisely the syntax should be to duplicate that password from the ASP.Net membership stuff
DataSource Controls :: How To Configure To Allow Windows Services Running On The Web Server To Access Sql Server
Jan 14, 2010We have a cient we are stting up that has 2 separate physical servers, one that is the web server the other the database server. Using impersonation we have been able to get the website to connect and retrieve data from the sql server so that part is not an issue. The problem is I have a windows service application that must be installed on the web server (as it process files downloaded to an ftp site) and it must be able to connect and write to the sql server as well.We tried adding a system.web block with the impersonation stuff to the app.config file which of course did not work. Can anyone tell me what/how we need to configure this properly?
View 7 RepliesIs It Possible To Browse To One Of The .rdl Reports In The Sql Server Reporting Services On The Report Server
Feb 11, 2010How is it possible to browse to one of the .rdl reports in the sql server reporting services on the report server?At present I can succesfully browse to the report by:http://servername/reportsthen I see a folder called "ReportFiles" which holds the reports (.rdl files)then I click on one of the .rdl files in there to see the report.Do you in asp.net know how I can go to one of the reports?
View 1 RepliesWCF / ASMX :: Calling DotNet Webservice From SQL Server Through CLR - Server Was Unable To Process Request
Nov 30, 2010I have a .Net Webservice(2.0 framework) and I am trying to call this service from SQL
server 2005 using CLR.
I have created assamblies on server and trying to call the we service through CLR, but I'm getting below error:
"Exception:
Server was unable to process request. ---> Invalid URI: The URI is empty."
AJAX :: Calling Server From Javascript And Have Access To Page Server Controls?
Nov 4, 2010I need to make an ajax call from my javascript and access a control on my page. Using a webmethod wont work then since it's static, do I have any other options?
View 3 RepliesCalling SQL Server Store Procedure WITHOUT Any Server Scripting Language?
Mar 13, 2015i have a sql server store procedure which return json data. i want to get this data without .net framwork or php or any other server side language..
So how make this possible to get json data of sql server query through any client scripting language like jquery ajax method.
Configuration :: Deploy Window Services And WCF Services Using Web Package?
Apr 3, 2010I am using Visual Studio 2010 Release candidate1. I have to deploy my web application which consists of a website, certain window services, certain WCF services and Sql Server 2005 database.I read Vishal Joshi's blog(http://vishaljoshi.blogspot.com/2009/09/overview-post-for-web-deployment-in-vs.html) detaing Web Package in VS2010. I want to know how to deploy window services and WCF services using Web Package. Also, I want to create a web setup (.msi) for deployment instead of Web Package so that the .msi takes care of all the application and database deployment like the web package does.
View 1 RepliesWant To Know About SQL Server Reporting Services?
Feb 17, 2011Can someone explain me about SQL Server Reporting Service and using it in ASP.net?Typically I design my reports by Crystal Report, assign the data source to crystal report an produce my report.What is the benefits of using SQL Server Reporting Service and how to use it?
View 4 RepliesConfiguration :: How To Deploy Wcf Services Into The Server
Dec 27, 2010i have created simple hello world WCF services it is working fine in local machine but when i try to uploaded to the server and then run that service it not at al start like http://localhost:8080/wcf/helloservice.svc
i am trying to modified the webconfig file <endpoint> address i have changed to my servername.com/wcf/helloservice.svc again it shows error can give usefull link to creation and deployment to the server