using System;
using System.Data;
using System.Data.SqlClient;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Configuration;
 
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class SlxService : System.Web.Services.WebService
{
    public SlxService() { }
 
    [WebMethod]
    public DataSet GetAccount(string AccountID)
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
        try
        {
            conn.Open();
 
            SqlDataAdapter da = new SqlDataAdapter("select * from account where accountid = @accountid", conn);
            da.SelectCommand.Parameters.Add("@accountid", AccountID);
 
            DataSet data = new DataSet();
            da.Fill(data);
            da.Dispose();
 
            return data;
        }
        finally
        {
            if (conn != null) conn.Dispose();
        }
    }    
}