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);
}