using System;
using System.Data;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Configuration;

namespace ATM
{
    class Program
    {
        static SqlConnection sqlconn = new SqlConnection();         //  Want it to be global
        sqlconn.ConnectionString = ConfigurationManager.AppSettings["cnStr"];   //
        static void Main(string[] args)
        {
        //code
    }

 class CDataset
        {
            public string sUserName;
            public string sPassword;

            public CDataset()
            {
            }

            public CDataset(string accountnbr, string password)
            {
                sUserName = accountnbr;
                sPassword = password;
            }

            public DataSet GetDataSetLogin()
            {
                SqlCommand sqlCmd = new SqlCommand();
                sqlCmd.Connection = sqlconn;        // sqlconn global???

                SqlCommand cmd = new SqlCommand("select accountnbr,password,balance from Accounts where accountnbr = @sUserName AND password = @sPassword", sqlconn);

                #region Parameters
                SqlParameter param = new SqlParameter();
                param.ParameterName = "@sUserName";
                param.Value = sUserName;
                cmd.Parameters.Add(param);

                SqlParameter param2 = new SqlParameter();
                param2.ParameterName = "@sPassword";
                param2.Value = sPassword;
                cmd.Parameters.Add(param2);
                #endregion

                SqlDataAdapter account = new SqlDataAdapter(cmd);
                DataSet ds = new DataSet();

                sqlconn.Open();
                account.Fill(ds, "Accounts");
                sqlconn.Close();
                sqlconn.Dispose();
                return ds;
            }
    }
    }
}