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


Post New Web Links

asp.net log in + webservice + sql server

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

Hi guys


I am trying to write a website. Before a user can use this website it has to provide it's username and password. These informations (username password) are saved on a sql server. I am also thinking to use web service   to control if the  informations  (username  password) that the user entered are correct. I also would like to use cookie (once a user get authenticated). As a web server am using IIS 7.5 .

My questions are:

1 - Once a user click log-in button it calls the web service which controls if these informations are stored on slq server. Lets suppose for a moment that they are correct. What command line do i have to use to tell the web server that the user now is authenticated.

2 - Do i have to tell the web server that it has to provide a cookie to the client or it does it by default.

3 - Let's suppose a user after get authenticated can do some operations on database. How can i tell the web service that this user is  already authenticated?? 

Sorry for bothering your guys but i really don't know where else to go...




View Complete Post


More Related Resource Links

Calling webservice from the server

  
Hi

I have a sample web service and aspx file. I deployed them to an existing website that contains classic asp files.

web-service: --- using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Services; [WebService(Namespace = "http://localhost/MyWebServices/")] public class MembershipRegisWebService : System.Web.Services.WebService { public MembershipRegisWebService () { //Uncomment the following line if using designed components //InitializeComponent(); } [WebMethod] public string HelloWorld() { return "Hello World."; } }

aspx.cs file: --- using System; using System.Collections.Generic; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.Services; public partial class CallWebService : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { MembershipRegisWebService mrWs = new MembershipRegisWebService(); Response.Write("Calling web service:" + mrWs.HelloWorld()); } }

It runs locally, but it shows an error when running it from the server:

Server Error in '/' Application. Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the follow

Webservice, server was unable to process request error

  

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Xml.XmlException: Data at the root level is invalid. Line 1, position 1.
   at System.Xml.XmlTextReaderImpl.Throw(Exception e)
   at System.Xml.XmlTextReaderImpl.Throw(String res, String arg)
   at System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace()
   at System.Xml.XmlTextReaderImpl.ParseDocumentContent()
   at System.Xml.XmlTextReaderImpl.Read()
   at System.Xml.XsdValidatingReader.Read()
   at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)
   at System.Xml.XmlDocument.Load(XmlReader reader)
   at BusinessObjects.OrderHelper.PlaceOrder(String StrorderXml) in C:\Documents and Settings\mchinta\My Documents\Visual Studio 2008\Projects\CcbApp\BusinessObjects\OrderHelper.cs:line 63
   at IServiceReference.IOrder.PlaceOrder(String orderXml) in C:\Documents and Settings\mchinta\My Documents\Visual Studio 2008\Projects\CcbApp\IServiceReference\IOrder.asmx.cs:line 24
   --- End of inner exception stack trace ---



Here is my XML

<?xml version='1.0' encoding='utf-8' ?><Order>Data</Order>


My S

asp.net webservice ERROR on production server.

  

Hi All,

 I'm using a web service in my asp.net 3.5 application.The web-service is hosted in my live server and it is working fine. My web application is also hosted in the same server.But when i try to access the webservice from my asp.net web application hosted online,I'm getting the following error.

[SocketException (0x274c): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond xx.xx.xx.xx:80]
   System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) +239
   System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP) +35
   System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception) +224



I'm able to call the online webservice from my web application hosted locally on my system and it is working fine.

Thanks in advance

Sandy


Does SQL Server 2005 support invoking secure (https) webservice as part of CLR proceduer/function ?

  

Does SQL Server 2005 support invoking secure (https) webservice as part of CLR proceduer/function ?

If yes, what exactly we need to do to make it working?

As I have a web service which is working fine for me if I'm calling it normally like "http://......" but same is generating error as below if I am calling it like "https:/..."

Error : The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.   at System.Net.HttpWebRequest.GetResponse()

 


Help - Cannot call webservice Get error: Server was unable to process request. --> Object reference

  
Here is my code, I don't fully understand the erro because I have instantiated all objects
Any help or advice appreciated.
  
Dim transactionResult As PremiumCredit.TransactionResult = New PremiumCredit.TransactionResult
        Dim newBusiness As PremiumCredit.NewBusiness = New PremiumCredit.NewBusiness
        Dim transferEngine As PremiumCredit.XMLTransferEngine = New PremiumCredit.XMLTransferEngine
        'Build up NewBusiness Object
        newBusiness.AddCoverCode = String.Empty
        newBusiness.BankAccountName = Session("BankAccountName").ToString
        newBusiness.BankAccountNumber = Session("BankAccountNumber").ToString ' 02149187
'Populate the rest of new Business object etc
        System.Net.ServicePointManager.ServerCertificateValidationCallback = New System.Net.Security.RemoteCertificateValidationCallback(AddressOf ValidateCertificate)
        Try
            transactionResult = transferEngine.Crea

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Making Ajax Callbacks to the Server Using jQuery with ASP.NET

  
In the first part of this article series I introduced jQuery's functionality and how it provides a rich client side programming model. This time around I'll expand on these concepts and show you how you can use jQuery in combination with ASP.NET using it as an AJAX backend to retrieve data. I'll also discuss how you can create ASP.NET controls and otherwise interact with jQuery content from ASP.NET pages in WebForms.


jQuery is just a JavaScript library so it will work seamlessly with ASP.NET both from page code as well as through backend driven code using the Page.ClientScript object or ScriptManager. You can use jQuery on its own as a client side and Ajax library that communicates with ASP.NET or you can use jQuery in combination with ASP.NET AJAX. The two actually complement each other quite well as jQuery provides functionality that the ASP.NET AJAX library does not and vice versa. For the most part the interaction between the two libraries is trouble free except for a few very rare edge cases.

MS SQL Server: Disconnect Users From Database - Kill User Session

  
If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

  
If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

  
We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

CLR Integration With Microsoft SQL Server

  
Transact-SQL provides as much flexibility as possible but, because it is not a real programming language, it has some shortcomings about many issues (memory management, exception handling, debugging, file processing (or streaming), object-orientation (classes), or thread management). Transact-SQL also lacks features of normal libraries (arrays, collections, serialization, expressions, or string manipulations, etc).

IP Address Blocking or Restriction in SQL Server

  
"is it possible to block connections to SQL Server based on IP address". As far as now there is no official way in SQL Server to block the connections in SQL Server based on IP address. However this can be done from the OS end, we have the following three options available, refer HERE for more.


.Firewall
.IPSec
.RRAS IP Filter

Determine whether Forms Server is installed on a server

  
Check whether the Microsoft.Office.InfoPath.Server.dll and FormServer.aspx files are installed on the server.

Connestion string create any database server

  
This links important to how to create connection string to any data base sever.

SQL Server Database Transaction

  
A transaction is a group of SQL commands executed together as a single component of work to be accomplished. If all of these commands succeed, then a transaction is committed - the changes to the data are made final. If any of the commands within a transaction fail, then the entire transaction is cancelled, or in SQL Server terms, the transaction will be rolled back.

Transactions are one of the things that keep your data safe, but they're not necessarily easy to understand. Here's some help:

SQL Server Backup and Restore (video)

  
Restore your full backup, then run a few queries before you keep restoring transaction logs. Brent shows how to use the Standby option for restores.

In this five minute video, Brent demonstrates how to do it by creating a database, populating data, and then showing what disaster recovery is like by doing RESTORE WITH STANDBY.
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