Creating a Web Service for a Login Page

Introduction:

Here I am creating a web service for a login check and consuming it in a web application. Follow the given steps to do it.

Step1: Create a web service using the following steps.

• Go to Visual Studeo 2010 and take a New Project.
• Select .NET Framework 3.5.
• Take a ASP.NET Web Service Application.
• Give it a name and click ok button.

Step 2: Write the following code on the .asmx.cs page.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data.SqlClient;
using System.Data;

namespace loginwebservice
{
/// <summary>
/// Summary description for Service1
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.ComponentModel.ToolboxItem(false)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
// [System.Web.Script.Services.ScriptService]
public class Service1 : System.Web.Services.WebService
{
[WebMethod]
public DataSet login(string uname, string pwd)
{
SqlDataAdapter da = new SqlDataAdapter("select * from login where user_name ='" + uname + "' and password='" + pwd + "' ",
@"DataSource=SERVER_NAME;Initial Catalog=EMP;Integrated Security=True");
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
}
}
}

Step 3: Run this application.

Output:

Step 4: Now create a web application to consume the service. For doing this, follow the given steps.

• Go to Visual Studeo 2010 and take a New Project.
• Select a ASP.NET Empty Web Application.
• Give it a name and click ok button.
  

Step 5: Now add service in your web application. Go to Solution Explorer and right click at your project. Click at Add Web Reference. A new window will open. Its screen-shot is given below.

• Now paste the URL of your service and click at Go button.
• Click on Add reference. Now service has added into your project.
• Now go to design page of your web application and take some user interfaces to accept user name and password and a button.
• Write the following code in the .aspx.cs file on buton Click event.
  
  protected void btnok_Click(object sender, EventArgs e)
  {
  localhost.Service1 obj=new localhost.Service1();
  DataSet ds = obj.login(TextBox1.Text, TextBox2.Text);
  if (ds.Tables[0].Rows.Count > 0)
  {
  Label1.Text = "Hi ," + ds.Tables[0].Rows[0][1].ToString();
  }
  else
  {
  Label1.Text = "Invalid UserName or Password.";
  }
  }
  

Step 6: Run the web application.

Output:



Write the user name and password in TextBoxes and click the ok Button. In this example, Database name is EMP which has a table Login. There is only one record in Login table - abc is user_name and xyz is password. Do right input for user name and password and click the ok button.

Output:

Now do wrong input for user name and password and click the ok button.

Output: