C# (CSharp) DALayer Sqlconn Examples

Example #1

        public string GetUserPassword(string paramUserName)
        {
            Sqlconn mySqlconn   = new Sqlconn();
            DataSet myDs        = new DataSet();
            string  returnValue = string.Empty;
            string  strSql      = "select passwd from user where 1=1";

            if (paramUserName.Length > 0)
            {
                strSql += " and  userName ='******'";
                myDs    = mySqlconn.Query(strSql);

                if (myDs.Tables.Count > 0 && myDs.Tables[0].Rows.Count > 0)
                {
                    returnValue = mySqlconn.ExecuteSql(strSql);
                    return(returnValue);
                }

                return(returnValue);
            }



            return(returnValue);
        }