The WebService still returns "Connection Successful" even SQL Server is off. Please Help.

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

Dear members and administrators,

Hello everyone, a pleasant day.

I've been studying C# for quite sometime and now I am doing a very simple Web application and a Web Service in which this Web Service will handle all database commands such as open, close, add a record, delete, and edit. So far, I am still stuck in opening a database.

This is the code of my Web Service, the file name is Service.asmx:

C#

using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data;
using System.Data.SqlClient;

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class Service : System.Web.Services.WebService
{

    private const string connectionString ="Server=MARK\\SQLEXPRESS2005;Database=SampleDatabase;Trusted_Connection=True;";
    
    string sqlQuery;
    DataSet dataSet;
    bool isConnectionFailed;
    SqlConnection sqlConnection;    
    
    public Service () {
        //Uncomment the following line if using designed components 
        //InitializeComponent(); 
    }

    [WebMethod]
    public void connectToDatabase(){
        sqlConnection = new SqlConnection(connectionString);
        try {
            sqlConnection.Open();
            isConnectionFailed = false;
        }
        catch (Exception exception) {
            isConnectionFailed = true;
        }
        finally {  }
        
    }//end connectToDatabase()


    [WebMethod]
    public string getConnectionMessage() {
        string message="";
        if (isConnectionFailed)
            message = "Error while connecting to Microsoft SQL Server.";
        else
            message = "Connection SUCCESSFUL!!!";

        return message;
    }    
}//end class

I tested it and it works fine.

Then I created a new Solution/Project, a Web Application in C#. Afterwards, I added my WebService as a Web Reference to this Web Project(or Solution). This is the code of
Default.aspx.cs:

C#

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

namespace WebProject
{
    public partial class _Default : System.Web.UI.Page
    {
        
WebServiceDatabase.Service service = new WebProject.WebServiceDatabase.Service();//My Web Service

        protected void Page_Load(object sender, EventArgs e)
        {
            service.connectToDatabase();
            lblConnectionMessage.Text = service.getConnectionMessage();
        }
    }
}

I tested it and it works fine. The web browser(IE) displays the string:
Connection SUCCESSFUL!!!

BUT, when I tried to disconnect/stop the service of my SQL Server and try to run again the Default.aspx, I am still recieving the same message (i.e. Connection SUCCESSFUL!!!). Is not that I should be receiving Error while connecting to Microsoft SQL Server because my SQL Server has stopped?

Can anyone help me how would I change my webservice code?

Thank you and more power.

Warm regards,

Mark

Posted 8-Mar-12 17:58pm

MarkSquall

Updated 8-Mar-12 18:02pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sushil Mate · Accepted Answer · 2012-03-08T18:10:00

Solution 1

something like this you can do.

public bool connectToDatabase(){
    sqlConnection = new SqlConnection(connectionString);
    try {
        sqlConnection.Open();
        return false;
    }
    catch (Exception exception) {
        return true;
    }
    finally {  }

}//end connectToDatabase()


[WebMethod]
public string getConnectionMessage() {
    string message="";
     bool isConnectionFailed = connectToDatabase();
    if (isConnectionFailed)
        message = "Error while connecting to Microsoft SQL Server.";
    else
        message = "Connection SUCCESSFUL!!!";

    return message;
}

Posted 8-Mar-12 18:10pm

Sushil Mate

Updated 8-Mar-12 18:11pm

v2

Comments

MarkSquall 9-Mar-12 0:27am

Hello sushil.mate,

Thank you very much for your idea, but unfortunately, we got the other string (i.e. Error while connecting to Microsoft SQL Server.) even I started my SQL Server.

Warm regards,

Mark

Sushil Mate 9-Mar-12 1:24am

Hi mark, the thing is that whenever you open the connection after your work you have to close the connection, if you don't every time the new connection has been created which is unnecessary. I can guess that you have opened many connections & now its not allowing to connect. Please go to Administrative tolls then services & restart the MSSQL$SQLEXPRESS service. & please close the connection once you done with it.. otherwise again you will face this kind of problem.