예제 #1
0
        public void prcGetLoginDetails(ref System.Data.DataSet ds, string userName, string userPassword)
        {
            clsConnection clsCon = new clsConnection();

            string sqlQuery = "Select *, getdate() as 'LoginDate' from viewLogin_User where IsInactive=0 and LUserName='******' and LUserPass='******'";

            clsCon.GTRFillDatasetWithSQLCommand(ref ds, sqlQuery);
            ds.Tables[0].TableName = "Login";
        }