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 

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();
        }
    }
}