title: web service in asp.net
body: <p>I want to create an web service for 'sign up' page or database connectivity.. </p>
  
  <p>I am done with database connectivity </p>
  
  <p>but i am unable to get how ca i design an sign up page in web service.. as there is no interface in web service.</p>
  
  <p>Please tell me</p>
  
  <p>my web service code is :</p>
  
  <pre><code>using System;
  using System.Collections.Generic;
  using System.Linq;
  using System.Web;
  using System.Web.Services;
  using System.Data;
  using System.Data.SqlClient;
  
  
  namespace WcfService1
  {
      /// &lt;summary&gt;
      /// Summary description for WebService1
      /// &lt;/summary&gt;
      [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 WebService1 : System.Web.Services.WebService
      {
          string Connection = "Data Source=SHUMAILA-PC;Initial Catalog=kse;User ID=sa;Password=sa";
          [WebMethod]
          public void SQLconn()
          {
              SqlConnection DataConnection = new SqlConnection(Connection);
              // the string with T-SQL statement, pay attention: no semicolon at the end of //the statement
              string Command = "INSERT INTO login VALUES ('hina','me12')";
              // create the SQLCommand instance
              SqlCommand DataCommand = new SqlCommand(Command, DataConnection);
              // open the connection with our database
              DataCommand.Connection.Open();
              // execute the statement and return the number of affected rows
              int i = DataCommand.ExecuteNonQuery();
              //close the connection
              DataCommand.Connection.Close();
  
          }
  
      }
  }
  </code></pre>